i have 1 table:
create table t1 ( id integer not null primary key, descri text )

then i exec... "SELECT * FROM t1" 

when i get the column type... with [ sqlite3_column_type(stmt,index); ] 
i get always (int)5 = SQLITE_NULL

every else is correct !, i have the correct row count, field count; values in 
each row/columns....

i do:
sqlite3_open
sqlite3_prepare ( "select * from t1" )
get sqlite3_column_count(stmt)
for 1 to colcount
   sqlite3_column_type(stmt,index)   "always return 5"
next
while (sqlite3_step=SQLITE_ROW)
    fetch & save
wend
sqlite3_finalize




      Yahoo! Cocina

Encontra las mejores recetas con Yahoo! Cocina.


http://ar.mujer.yahoo.com/cocina/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to