CAVALO SCHMIDT wrote:
In the following simple C code (in Console program):sqlite3 *db; int ret = sqlite3_open("dict.db", &db); sqlite3_stmt *stmt; char sql[256]; sprintf(sql, "%s", "select * from a where a = 'key1'"); int rc = sqlite3_prepare(db, sql, 0, &stmt, 0); while(sqlite3_step(stmt) == SQLITE_ROW) { printf( (char *)sqlite3_column_text(stmt, 1) ); }; sqlite3_finalize(stmt); sqlite3_close(db); I must have made a very simple beginner mistake, because an error happens. sqlite3_prepare returns SQLITE_OK, but sqlite3_step returns 21 = SQLITE_MISUSE. Can anyone tell me what I did wrong? It happens with any database I test it with. Just for information, sqlite3_exec works perfectly.
You have called sqlite3_prepare incorrectly. The third argument is the length of the sql string if it is positive. To have sqlite scan until the end of the string you need to pass a negative number. Tyr this instead.
int rc = sqlite3_prepare(db, sql, -1, &stmt, 0); HTH Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
