[Gambas-user] mysql float behaviour

[Benoît Minisini]

Le 27/06/2012 10:48, Bill-Lancaster a écrit :
>
> 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
>

You must write the request that way:

$Conn.Find("salesinvoices", "InvoiceNumber = &1", fInr)

-- 
Benoît Minisini