Subject Re: Update syntax From Tom <IHaveNoEmail@ddress> Date Sat, 13 Feb 2021 08:18:02 -0500 Newsgroups dbase.getting-started Attachment(s) TableStructure.png 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 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 > Gentlemen, 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. Tom