RAKESH HEMRAJANI <rakesh_hemraj...@hotmail.com> wrote: > int i=0; > rc = sqlite3_exec(db, "insert into emp values(i);", 0, 0, &zErrMsg);
Use sqlite3_prepare_v2, sqlite3_step, sqlite3_bind_* et al to run a parameterized query. Something like this: sqlite3_stmt* stmt; sqlite3_prepare_v2(db, "insert into emp values(?);", -1, &stmt, NULL); for (int i = 0; i < 10; ++i) { sqlite3_bind_int(stmt, 1, i); sqlite3_step(stmt); sqlite3_reset(stmt); } sqlite3_finalize(stmt); This example also shows how you can run the same statement multiple times with different values for parameters. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users