flakpit wrote: > > Peter Holmes-4 wrote: >> Yep. Works great! For example: >> >> sqlite3_prepare_v2(db,"INSERT INTO ans VALUES (?,?);",-1,stmt,NULL); >> sqlite3_bind_text(stmt,0,"Peter's",-1,SQLITE_STATIC); >> sqlite3_bind_text(stmt,1,"Reply",-1,SQLITE_STATIC); >> sqlite3_step(stmt); >> sqlite3_reset(stmt); >> > > so ?,? represent columns to be filled in right?
Yep. > and stmt,0 is column 0 and stmt,1 is column 1? Yep, but the first column is 1 (see the last posted version of the snippet which corrects my previous errors). Watch out when retrieving values from SELECT output because in that case the first column is 0. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
