Subject Re: Update syntax From Gaetano D. <gaetanodd@hotmail.com> 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 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 > 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.