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.
I should have tried harder!
Found the mysql CAST function which does the trick.
--
View this message in context:
http://old.nabble.com/mysql-float-behaviour-tp34077473p34077592.html
Sent from the gambas-user mailing list archive at Nabble.com.
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
Thank you Benoît - it worked fine.
Where can I find more info re this '1' ?
--
View this message in context:
http://old.nabble.com/mysql-float-behaviour-tp34077473p34079666.html
Sent from the gambas-user mailing list archive at Nabble.com.
On Wed, 2012-06-27 at 04:25 -0700, Bill-Lancaster wrote:
Thank you Benoît - it worked fine.
Where can I find more info re this '1' ?
Hi Bill,
It's in the help at gb.db.Connection.Subst
You're right.
Connection.Find ( Table As String [ , Request As String,
Arguments As , ... ]
!
-- Original Message ---
From: Bruce bbr...@paddys-hill.net
To: mailing list for gambas users gambas-user@lists.sourceforge.net
Sent: Wed, 27 Jun 2012 22:02:29 +0930
Subject: Re: [Gambas-user] mysql float behaviour
On Wed, 2012-06-27 at 04:25 -0700, Bill-Lancaster wrote