> Ya now i am getting error code which says SQLITE_DONE...so how can get my
> resultant now?
> Which API i should use?Please tell me
After running prepare, you can get the data like this:
//This while loop will step through every row one by one
while (sqlite3_step(pStmt) == SQLITE_ROW)
{
//This will store the data from the first column in the row
char* cData = (const char*)sqlite3_column_text(pStmt, 0);
//to get data from additional columns, just specify which one in
that //last value, like so:
char* cData2 = (const char*)sqlite3_column_text(pStmt, 1);
}
//Don't forget to call this when you're done:
sqlite3_finalize(pStmt);
---
Hope that helps
Richard
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
