On 19 Jan 2019, at 3:57am, Stephen Chrzanowski <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
