2009/11/11 TTTTT <erlichk...@gmail.com>: > . . . > >> 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*);
>From http://www.sqlite.org/c3ref/column_blob.html: "These routines form the "result set query" interface." If you want to see the data, you need to get it using the sqlite3_column_xxx() routines after each call to sqlite3_step(). If your column contains an integer, use sqlite3_column_int(), for real values use sqlite3_column_double(), and so on. > > maybe? > > Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users