Subject Re: Update syntax
From Tom <IHaveNoEmail@ddress>
Date Sat, 13 Feb 2021 08:18:02 -0500
Newsgroups dbase.getting-started
Attachment(s) TableStructure.png

On 2/12/21 4:25 PM, Tom wrote:
> On 2/12/21 4:00 PM, Mervyn Bick wrote:
>> On 2021/02/12 22:39, Tom wrote:
>>> dBase
>>> Windows 10 Pro
>>> Trying to do an 'Update' on a dBase 7 table and getting the attached
>>> error message. Copy of pertinent code included. Do you see the cause
>>> of the error?
>>> Tom
>> The values for bArchived and bShared must be false and true (no quote
>> marks) not 'false' and 'true'.
>> Mervyn.
> RevisedCode and RevisedMsgbox attached.
> Pretty sure I tried that before posting. Further suggestions?
> Tom


I may have the solution to the problem. However, the wife frowns on me
jumping out of bed at 01:30 am to test code. I have included the table
structure image for your benefit in the mean time. As soon as I am fully
awake and can do some tests I will get back to you.