[Gambas-user] mysql float behaviour

[Bill-Lancaster]

Have recently changed my db from sqlite3 to mysql.
With sqlite3:-    $Conn.Find("salesinvoices", "InvoiceNumber = " & fInr)
would correctly return 1 record.  InvoiceNumber is defined as float.
With mysql, no records are found.
I can change the definition type of InvoiceNumber but it needs to numeric.

Any ideas?

Gambas 3
Ubuntu 12.04, KDE 4.8.1, mysql Server version: 5.5.24
-- 
View this message in context: http://old.nabble.com/mysql-float-behaviour-tp34077473p34077473.html
Sent from the gambas-user mailing list archive at Nabble.com.