||Re: Update syntax
Gaetano D. <email@example.com>
||Sat, 13 Feb 2021 09:36:08 +1000
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 18.104.22.168
>>> 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?
>> The values for bArchived and bShared must be false and true (no quote
>> marks) not 'false' and 'true'.
> RevisedCode and RevisedMsgbox attached.
> Pretty sure I tried that before posting. Further suggestions?
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.