Jeff Archer <jsarc...@nanotronicsimaging.com> wrote: > Is it possible to use parameter binding from the sqlite3 command line utility?
No. > In my code I have tried making 1 bind to @MicroscopeID and I have tried it > with > appending the digits 1 to 6 and making 6 calls to bind with same result. You were making these 6 calls to bind on 6 different statement handles, I hope? Anyway, you are doing something wrong. Show your code. You are supposed to insert NULL in Microscopes.MicroscopeID. Since it's INTEGER PRIMARY KEY, a unique value will be generated for it. You retrieve this value with sqlite3_last_insert_rowid, then bind MicroscopeID parameter to it in all the other statements. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
