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