So I checked out the lessons. I do not find anything there for using substitutions like :1, :2. I am getting records inserted but with empty data. Really frustrating.
I could use literal data, which I tested, and which works, but my real data contains commas, and in the future may contain any number of special characters that I will have to escape. Not my idea of fun. I was hoping to do a "quickie" implementation but it seems I will have to run this through sqlYoga like everything else I do these days. Bob S > On Jul 6, 2021, at 16:26 , Bob Sneidar via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Well that won't work. How does it know I want to insert the data in > aRecordData? Also I put quotes around the column names but got the same > results. > > Bob S > > >> On Jul 6, 2021, at 16:14 , Devin Asay via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> revExecuteSQL “aRecordData” >> >> Not tested, but I’m pretty sure if you sort these things it will start to >> work for you. >> >> - Devin > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
