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. ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
