||Re: Update syntax
Gaetano D. <email@example.com>
||Sat, 13 Feb 2021 09:05:34 +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 188.8.131.52
>>> 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?
Assuming that all field types match, nothing stands out as being the
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.