I think the OP wanted to know how to find this programatically. In that case see sqlite3_column_type() function call.
Cheers, Mark On Fri, 2010-02-05 at 02:47 +0000, Simon Slavin wrote: > On 5 Feb 2010, at 2:41am, gujx wrote: > > > Maybe I didn't express the problem clearly. > >> e.g. if you have a text value, you use _text(), if you have an int, you > >> use _int() > > I just don't know what type I have, so I want to get the meta type of the > > column somebody defined. > > e.g. I'd like to use a bind routine to bind a variable t to a "?", but I > > don't konw this t is a string or a number or it is a object, so I want to > > know that the table is defined like "id(varchar)" ,then I will use > > sqlite3_bind_text; or it is defined like "id(integer)", then I will choose > > sqlite3_bind_int. > > Open the database in the command-line tool, and use the .schema command: > > <http://www.sqlite.org/sqlite.html> > > Simon. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- * Mark Hessling, m...@rexx.org http://www.rexx.org/ * Author of THE, a Free XEDIT/KEDIT editor, Rexx/SQL, Rexx/CURL, etc. * Maintainer of Regina Rexx interpreter and Rexx/Tk * Use Rexx? join the Rexx Language Association: http://www.rexxla.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
