nick huang <nickhuan...@hotmail.com> wrote: > 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.
This statement should in fact return one row, with the value of NULL. How do you retrieve the value? If you use sqlite3_column_int, it'll convert NULL to 0 for you. Check with sqlite3_column_type. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
