2010/1/27 gujx <[email protected]>:
> Hi, I had a question puzzled me. How can I get the type of a parameter in a
> prepared SQL.
>
> For example, the code is:
.
.
.
>
>       "INSERT INTO [test_for_cpp] ([id], [age], [name]) VALUES (?, ?,
> 'xiaowang') ; ",
>       -1,
>       &ppStmt,
>       &pzTail
>    );
>
> How can I get the type of the specific column that a “?” referenced to?
> For example, I want to get the type (here is integer) of the first column
> that the first “?” referenced to.

pragma table_info, see http://www.sqlite.org/pragma.html#pragma_table_info

>
> Gu Jinxiang
>

Regards,
Simon
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to