Thank you, it now works.
2007/12/13, Dennis Cote <[EMAIL PROTECTED]>:
>
> 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]
>
> -----------------------------------------------------------------------------
>
>
