I am really sorry, The correct code is given below: /********************************************************************************/ #include <stdio.h> #include <stdlib.h> #include <stdint.h> #include <string.h> #include <sqlite3.h>
const char *create_and_insert = "create table some_tbl (id int primary key, version text check (version in (\"1.0\")));" "insert into some_tbl (id) values (1);"; const char *update_sql = "update some_tbl set version = ? where id = ?"; int32_t main(int32_t argc, char *argv[]) { sqlite3 *db; char *err_msg; sqlite3_stmt *stmt; int32_t ret; if (argc != 2) { fprintf(stderr, "Usage: %s <database name>.\n", argv[0]); goto out1; } db = NULL; ret = sqlite3_open(argv[1], &db); if (ret != SQLITE_OK) { fprintf(stderr, "Unable to open database.\n"); goto out1; } err_msg = NULL; ret = sqlite3_exec(db, create_and_insert, NULL, NULL, &err_msg); if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_exec: %s.\n", err_msg); sqlite3_free(err_msg); } stmt = NULL; ret = sqlite3_prepare_v2(db, update_sql, strlen(update_sql) + 1, &stmt, NULL); if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_stmt: %s", sqlite3_errmsg(db)); goto out2; } /* The second argument indicates the posistion of the column */ ret = sqlite3_bind_text(stmt, 1, "1.0", strlen("1.0") + 1, SQLITE_TRANSIENT); if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_bind_text: %s", sqlite3_errmsg(db)); goto out3; } ret = sqlite3_bind_int(stmt, 2, 0); if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_bind_int: %s", sqlite3_errmsg(db)); goto out3; } ret = sqlite3_step(stmt); if (ret != SQLITE_DONE) { fprintf(stderr, "sqlite3_step: %s", sqlite3_errmsg(db)); goto out3; } ret = sqlite3_finalize(stmt); if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_finalize: %s", sqlite3_errmsg(db)); } ret = sqlite3_close(db); if (ret != SQLITE_OK) { fprintf(stderr, "Unable to close the database.\n"); } exit(0); out3: ret = sqlite3_finalize(stmt); if (ret != SQLITE_OK) { fprintf(stderr, "sqlite3_finalize: %s", sqlite3_errmsg(db)); } out2: ret = sqlite3_close(db); out1: exit(1); } /*********************************************************************************/ Simon Slavin wrote: > On 27 Jun 2009, at 8:47am, chandan wrote: > > >> const char *create_and_insert = "create table some_tbl (id int primary >> key, version text check (version in (\"1.0\")));" >> "insert into some_tbl (id) values (1);"; >> const char *update_sql = "update some_tbl set version = ? where id >> = ?"; >> > > I note you then do > > ret = sqlite3_bind_int(stmt, 2, 0); > > doesn't this look for id=2 ? > > > > > To diagnose your problem, first try the whole thing as text: execute > the command > > update some_tbl set version = '1.0' where id = 1 > > and see if it works. If it doesn't, try it in sqlite3 command-line > tool and see if that works. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users