On 21/06/2012 11:47 PM, Simon Slavin wrote:
Are you examining the result code returned by the SELECT commands ? I bet in
the cases where the select gets zero rows, it isn't returning SQLITE_OK but
it's instead returning some sort of error code.
Simon.
Hi Simon,
Yes, I do examine those and the return is SQLITE_DONE in this case. I
typically check for SQLITE_ROW to get the results and bail out on
anything else. The prepare does return a SQLITE_OK.
Dennis
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users