||Re: Update syntax
||Sat, 13 Feb 2021 08:18:02 -0500
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 220.127.116.11
>>> 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 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.