[sqlite] how to get the meta type of a column

[gujx]

There is a table like this:


id(varchar)

name(text)

age(integer)

ss(text)

Its name is “test_for_cpp”, now I get the pointer of sqlite successfully. 

 

There are codes below:

 

    sqlite3_stmt *ppStmt;

    const char *pzTail;     

    int nVal = sqlite3_prepare_v2(

       conn,           

       "INSERT INTO [test_for_cpp] ([id], [name], [age], [ss]) VALUES (?, ?,
?, ’exa’) ; ", 

       -1,            

       &ppStmt,  

       &pzTail    

    );

 

now, I should use routines such as
<http://www.sqlite.org/c3ref/bind_blob.html> sqlite3_bind_text to bind data
with the “?”, but I don’t know the exact meta type of the column. 

I don’t know that the meta type of the column id is “integer”, and I
don’t know the meta type of the column name is “text”.…… So, I can’t
choose the exact bind routine.

Is there any way to resolve this?

 

 

 

Gu Jinxiang

 

以上、よろしくお��いします。

 

-- 

 

 


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users