I have a sqlite3_get_table query that sometimes returns error code 100 (
SQLITE_ROW). Can someone explain what condition would cause this - I
didn't think that this return code would happen for this function, since
it should fill up the 'results' table.
The query sometimes works, sometimes not... this is in a 'busy'
application, it is not clear what condition causes this return code. It
is *possible* that there is a locking problem, but I would have expected
a different code (e.g.: SQLITE_BUSY). There is only one process, and
only one open connection to the database. The query does not return a
large amount of data - 1 or 2 K at most. System resources (i.e.: memory
and disk) are more than adequate for the task.
Some additional information:
This is sqlite version is 3.3.4.
nrows and ncols are both 0.
result does not appear to be set to 'real' data.
sqlite3_errmsg(db) returns an empty string.
Thanks
*** Doug Fajardo