I know about the bindings. I don't know about all languages supporting it.
On Fri, Jan 18, 2019 at 11:26 PM Simon Slavin <slav...@bigfraud.org> wrote: > On 19 Jan 2019, at 3:57am, Stephen Chrzanowski <pontia...@gmail.com> > wrote: > > > I was going to have three variable set with > > three different strings I could just copy/paste to generate that > > comparative list. > > You know SQLite does binding, right ? You don't have to construct your > command like > > command$ = "INSERT INTO MyTable VALUES ("+a$+","+b$+","+c$+")" > > You can do this: > > command$ = "INSERT INTO MyTable VALUES (?,?,?)" > > or > > command$ = "INSERT INTO MyTable VALUES ($name,$address,$phone)" > > and maintain the variables in whatever programming language you're using. > You just have to remember to bind before you tell SQLite to execute > command$. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users