| Subject | Re: Update syntax |
| From | Mervyn Bick <invalid@invalid.invalid> |
| Date | Sat, 13 Feb 2021 15:56:05 +0200 |
| Newsgroups | dbase.getting-started |
On 2021/02/13 15:18, Tom wrote: > 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. There are many cases in which a picture is worth a thousand words. This isn't one of them. :-) If you had posted the actual code snippet and an empty copy of the table itself I could put together a working example for you. I have a choice of painstakingly building a table by referring to your screenshot or sitting in the recliner on a Saturday afternoon watching soccer on the box. Guess which one is going to win. :-) Still, the picture has clarified things. As I posted in a previous message, the DemDataID field is character (as I surmised) so you need to wrap the value to be inserted in quotes. ..... cmd += [ WHERE DemoDataID = '] + form.oParent.qGRID.rowset.fields["DemoDataId"].value + ['] Mervyn. | |