When I use sqlite ado.net, I met a bug made me confused.
My table schema and data is like this. Table name is "a".
ID TEXT DOUBLE
1 AA 1
2 BB 1.2
3 CC 2
When I run SQL statement("select * from a");
I got double column's data is 1 1 2, and column dataType is system.Int64(Long)
the 1.2 converted to 1. this make me got wrong value.
But, if table is like this.
ID TEXT DOUBLE
1 AA 1.3
2 BB 1.5
3 CC 2
I got double column's data is 1.3 1.5 2, and column dataType is double
the dataType and correct value is very import for us.
I can not create a dataTable that defined tableschema, because the select
result is can not prediction. I can not know how many columns and column's data
type will be return.
Please try this. If this is a bug, please fixed it as soon as possible.
If this is not a bug, can you give me a way to get correct value and column
type ?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
