hi,
I am a sort of new to sqlite. I include sqlite in my project and then encounter such a problem. Say a table named "url" is created with "id" as primary key. Then a query like this "select min(id) from url". Quite unexpectedly, the result of query returns "SQLITE_ROW" and the min(id) is 0. However, my table is still empty which confuses me for a while. Please note my project is C/C++ program and I just include sqlite source code in my project. I am not sure about the version number. In the "sqlite3.c", there is such line "This amalgamation was generated on 2009-08-10 13:49:19 UTC." In sqlite3.h, there is a line @(#) $Id: sqlite.h.in,v 1.462 2009/08/06 17:40:46 drh Exp $ Some other details as following: Open DB with sqlite3_open. Open table with sqlite3_prepare/sqlite3_step Best regards, Nick Huang/Qingzhe Huang nickhuan...@hotmail.com ÎÒµÄÕ÷³¾ÊÇÐdz½´óº£¡£¡£¡£ (Chinese) http://www.staroceans.com/ The dirt and dust from my pigremage form oceans of stars... (English) http://www.staroceans.com/english.htm _________________________________________________________________ Ready. Set. Get a great deal on Windows 7. See fantastic deals on Windows 7 now http://go.microsoft.com/?linkid=9691818 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
