Subject Re: Update syntax
From Gaetano D. <>
Date Sat, 13 Feb 2021 09:05:34 +1000
Newsgroups dbase.getting-started

On 13/02/2021 7:25, 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
Assuming that all field types match, nothing stands out as being the
obvious culprit.

I would suggest to include only one character field in the update
statement (they would accept anything - that sets a baseline about the
update statement working), and execute it, then add one field at a time
until you find the culprit. Start with  the date/timestamp fields which
are more likely culprits for a data type mismatch, then the numeric
values, then the logical ones.