SQL Insert Syntax
bonnmike at gmail.com
Fri Jan 5 16:32:46 EST 2018
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
On Fri, Jan 5, 2018 at 2:24 PM, Bob Sneidar via use-livecode <
use-livecode at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode