Subject Re: Update syntax
From Gaetano D. <gaetanodd@hotmail.com>
Date Sat, 13 Feb 2021 09:36:08 +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 13.2.0.0
>>> 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 get the error when using a DMY format for a timestamp field or omit
the leading zero for the "hour" but you do neither of these things. Just
in case, try with different DT format, e.g. hard code '2021-02-12
04:19:27 PM' for LogDT to see if that changes anything.