[sqlite] "is not null" and index

Hi I have the following table: CREATE TABLE x ('col1', 'col2', 'col3') Create col1index on x ('col1') When I run this query: "select * from x where col1 is null" I see the index on x is used. When I run this query: "select * from x where col1 is NOT null" I see the index on x is not used.

[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

Thanks. It is indeed a problem with a temp file - I set the temporary directory with an uninitialized value. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

Hi We are building a Windows application using a read-only Sqlite database. When executing many queries in a short time, we sometimes get SQLITE_CANTOPEN from sqlite3_step. Checking GetLastError gives us error code 123: The filename, directory name, or volume label syntax is incorrect. If we

[sqlite] FTS and sorting

Hi What is the most efficient way to sort a result set from an FTS table? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users