Folks I have a C program that creates in-memory database with unique column. My code basically inserts row in database and if it gets duplicate row it selects the duplicate row from database and prints information.
The problem is that when I select the row it says row not found. I simplified the code as follows: sqlite3_prepare("insert statement") sqlite3_bind columns sqlite3_step sqlite3_finalize sqlite3_exec COMMIT When I insert the row I get following error message: column MD5Sum is not unique So I immediately do a select as follows: sqlite3_prepare("select statement") sqlite3_bind column sqlite3_step sqlite3_finalize But I do not get SQLITE_ROW return code. Here is my code. sqlite3_prepare(select statement) sqlite3_bind_text(SelectStmtHandle, 1, MD5Sum, strlen(MD5Sum), SQLITE_TRANSIENT); ReturnCode = sqlite3_step(SelectStmtHandle); if (ReturnCode != SQLITE_ROW) { sqlite3_reset(SelectStmtHandle); printf("Row not found. %s\n", sqlite3_errmsg(DbHandle)); return(2); } Here is the message it prints: Row not found. not an error I am new to sqlite, what am I doing wrong? What return code should I get if there is only one row in result set? I print the columns before I do insert and I can see that I have duplicate row. Sixth column (MD5SUM) is the unique column. 1219 10.136.28.112 44376 239.56.112.112 8146 dd5b8911bf377682d8963a859b8c2055 2010-09-24 14.11.07.545436 1219 10.136.28.112 44376 239.56.112.112 8146 dd5b8911bf377682d8963a859b8c2055 2010-09-24 14.11.07.545855 Hemant Shah E-mail: hj...@yahoo.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users