[sqlite] Re: Null row detection when doing sqlite3_step

2007-04-12 Thread Igor Tandetnik
pompomJuice <[EMAIL PROTECTED]> wrote: Basically I am looking for somthing simular to oracle's code 1403 where a query returned zero rows. If a resultset is empty, the very first call to sqlite3_step would return SQLITE_DONE (normally it would be SQLITE_ROW). That's your cue. How do I know

[sqlite] Re: Null row detection when doing sqlite3_step

2007-04-12 Thread Igor Tandetnik
pompomJuice <[EMAIL PROTECTED]> wrote: What is the best way to determine that sqlite3_step returned a null now? I'm not sure what you mean by sqlite3_step returning a NULL. I assume you mean it returns a row one or more columns of which contain NULL values. You can check that with