[Gambas-user] sqlite integer to text string problem

[charlesg]

Hi,

SQLite is a bit unusual. As the FAQ at www.sqlite.org says, the field type
is is one of expectation rather than definition (with the exception of an
integer primary key). This is demonstrated in your example where you have
put real numbers (0.64) into an integer field. SQLite doesn't care: it
treats everything as a string anyway.

I suspect you will get the correct value within Gambas with val(res!sclose)
where res is the result of the connection.exec

rgds
-- 
View this message in context: http://www.nabble.com/sqlite-integer-to-text-string-problem-tp23424393p23441371.html
Sent from the gambas-user mailing list archive at Nabble.com.