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