Ok it makes sense, but how can I get the number of rows in my query then ?
Thanks, Mario Hebert Legerity > strcpy( query, "select count(*) from dummy"); > rc = sqlite3_prepare( memdb, query, strlen(query), &pStmt, NULL); > rc = sqlite3_bind_text( pStmt, 1, query, strlen(query), > SQLITE_STATIC); You don't have any parameters in your query. What exactly do you expect your value to bind to? You appear to misunderstand the purpose of sqlite3_bind_* APIs. It's for parameterized queries, e.g. select * from dummy where somefield=? Now you can prepare this statement, bind a string "abc" to its only parameter, and step through it. It would execute as if the query had somefield='abc' condition. Then, you can reset it, bind a different string (say "xyz") to the parameter and step again. This time it will run with somefield='xyz' condition. Igor Tandetnik
