why not: int smth = sqlite3_step (statement2); while( smth == SQLITE_ROW ) { printf( "\n command= %s result code = %d \n", command, smth ); smth = sqlite3_step (statement2); } so that it will work no matter how many rows
because I dont have much experience :) that works great, thank you > and finaly i get SQLITE_DONE but it still doesnt show me table i have > selected... See http://www.sqlite.org/c3ref/column_blob.html i dont understand what exactly do you mean.. combination of these: sqlite3_value *sqlite3_column_value(sqlite3_stmt*, int iCol); typedef struct Mem sqlite3_value; void sqlite3_result_value(sqlite3_context*, sqlite3_value*); maybe? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- View this message in context: http://old.nabble.com/execute-or-prepare%2Bstep%2Bfinalize-tp26299247p26300548.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users