ya....I got now... But where as when i am executing the same from command prompt it is showing the OID alone. Why it is showing DONE when i am doing it through program?Anything wrong? Whether i should do in some other way? please help me
-Sandhya ----- Original Message ----- From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <[email protected]> Sent: Friday, September 15, 2006 8:27 PM Subject: [sqlite] Re: Re: Which API to use to get resultant of query > sandhya <[EMAIL PROTECTED]> wrote: > > Ya now i am getting error code which says SQLITE_DONE > > It's not an error. It's a success code meaning that you've reached the > end of resultset. If you get that on the very first call to > sqlite3_step, it means your resultset is empty - there are no rows > matching your condition. > > When sqlite3_step successfully retrieves a row from resultset, it > returns SQLITE_ROW. At this point, use sqlite3_column_* calls to > retrieve individual fields from this row. E.g. > > int oid = sqlite3_column_int(pStmt, 0); > > Igor Tandetnik > > > -------------------------------------------------------------------------- --- > To unsubscribe, send email to [EMAIL PROTECTED] > -------------------------------------------------------------------------- --- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
