Hello Folks I have some problem retrieving a result from a sqlite database in C.
I have the following statement: int func(void) { // database is open and the select statement is executed // this is the query: char *sql = "SELECT 'protect' FROM 'test_db');"; struct sqlite3_stmt *oStmt; int rc; int result = 0; if((rc=sqlite3_prepare_v2(db,sql,strlen(sql),&oStmt,NULL))==SQLITE_OK) { if((rc=sqlite3_bind_int(oStmt,0,result))==SQLITE_OK) { if((rc=sqlite3_step(oStmt))==SQLITE_ROW) { printf("result: %i\n",result); return result; } } } else { printf("SQL Error: %s\n",sqlite3_errmsg()); return -1; } } } But i always get the following error message: "Bind or column index out of range" What did i do wrong? Thanks for your help -- Freundliche Grüsse // Kind regards Severin A. Mueller Mythenquai 2 CH-8022 Zurich Office: +41 44 278 85 03 Mobile: +41 76 249 85 38 GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein: http://www.shortview.de/[EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users