e no grief !
-- Original Message ---
From: Bruce
To: mailing list for gambas users
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:
> > Thank you Benoît - it worked fine.
&
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 , ...
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.
-
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 t
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.
--
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 numer
