Use the placeholder method?
put your data into a numerically keyed array and change the insert to this..
INSERT INTO arraydata ("rect","controlname","owner","visible") VALUES
(:1,:2,:3,:4)On Fri, Jan 5, 2018 at 2:24 PM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > Possibly, but every sqLite reference I've looked at seems to indicate that > I should enclose string values with single quotes, and since my text > contains double quotes, I thought that would do the trick. I have tried > escaling quotes ie. \" but that doesn't work either. > > This BTW is why I use sqlYoga, so I don't have to deal with this syntax > crap, but I am writing a function that I want to be universally viable. > > Bob S > > > > On Jan 5, 2018, at 13:18 , Devin Asay via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > > Bob, > > > > Some SQL dialects accept both single and double quotes as string > delimiters. Might that be the problem? > > > > 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
