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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
