Stuck on native database functions
bobsneidar at iotecdigital.com
Tue Jul 6 19:51:04 EDT 2021
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.
> On Jul 6, 2021, at 16:26 , Bob Sneidar via use-livecode <use-livecode at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode