[Gambas-user] mysql float behaviour

2012-06-27 Thread 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.

Re: [Gambas-user] mysql float behaviour

2012-06-27 Thread Bill-Lancaster
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.

Re: [Gambas-user] mysql float behaviour

2012-06-27 Thread 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

[Gambas-user] ListView - Multiselect

2012-06-27 Thread Valeriu
Good day! How to select the selected items from the list ? Thank you. My code: ??? Dim i As Integer Dim ListGlobals As String ListGlobals = Select Message.Question(We delete the Global(s) File1.Item.Selected , yagree ?..., Yes, No, Don't know) Case 1 'For i =

Re: [Gambas-user] mysql float behaviour

2012-06-27 Thread Bill-Lancaster
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.

Re: [Gambas-user] ListView - Multiselect

2012-06-27 Thread Valeriu
Maybe I'm wrong explained. With my bad English ... In ListView i have marked for deletion from the list of multiple items. I want to get these items separately celebrated in a variable. How should i do? Any suggestions are accepted. Valeriu wrote: Good day! How to select the selected

Re: [Gambas-user] ListView - Multiselect

2012-06-27 Thread Bruce
On Wed, 2012-06-27 at 03:44 -0700, Valeriu wrote: Good day! How to select the selected items from the list ? Thank you. My code: ??? Dim i As Integer Dim ListGlobals As String ListGlobals = Select Message.Question(We delete the Global(s) File1.Item.Selected ,

Re: [Gambas-user] mysql float behaviour

2012-06-27 Thread Bruce
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 , ... ]

Re: [Gambas-user] ListView - Multiselect

2012-06-27 Thread Valeriu
Bruce, thank you, everything is fine! Valeriu bbb888 wrote: On Wed, 2012-06-27 at 03:44 -0700, Valeriu wrote: Good day! How to select the selected items from the list ? Thank you. My code: ??? Dim i As Integer Dim ListGlobals As String ListGlobals = Select

[Gambas-user] A bit of good news! (Relates to override, native classes, etc)

2012-06-27 Thread Bruce
Thanks to everyone here that followed and contributed to the various native class overrides threads and especially Benoit for the speedy fix to issue 261 and for the profiler, I am really pleased to announce the following: We process about 30 to 250 text files a day (depending on the day of the

Re: [Gambas-user] mysql float behaviour

2012-06-27 Thread nando
Primary keys are supposed to be unique unrelated to the actual data such as an INT with auto increment so there will never, ever be duplicates. If you use actual data (like a name) you CAN get duplicates and you are breaking the design theory. If you think you'll never get a duplicate, you will.

Re: [Gambas-user] Bug with JIT and external functions

2012-06-27 Thread Jussi Lahtinen
Yes, it works now! Jussi On 27 June 2012 00:12, Emil Lenngren emil.lenng...@gmail.com wrote: It seems like when LLVM reads boolean pointers, it assumes the seven most significant bits are always 0, which is not the case in Gambas. Does the latest revision work? I have no opportunity to

Re: [Gambas-user] Issue 258 in gambas: Expander and slider combo issues

2012-06-27 Thread gambas
Updates: Status: Fixed Comment #4 on issue 258 by benoit.m...@gmail.com: Expander and slider combo issues http://code.google.com/p/gambas/issues/detail?id=258 Since revision #4865, SidePanel got a popup menu that allows to toggle its transparency. Moreover, the IDE automatically

Re: [Gambas-user] Issue 260 in gambas: News on Gambas home page displays differently based on browser

2012-06-27 Thread gambas
Comment #2 on issue 260 by emil.len...@gmail.com: News on Gambas home page displays differently based on browser http://code.google.com/p/gambas/issues/detail?id=260 Why no scrollbars? On my tiny 1024x800 screen I only see 3 lines of the news.

Re: [Gambas-user] Issue 260 in gambas: News on Gambas home page displays differently based on browser

2012-06-27 Thread gambas
Comment #3 on issue 260 by benoit.m...@gmail.com: News on Gambas home page displays differently based on browser http://code.google.com/p/gambas/issues/detail?id=260 Just click on the click there to see all news button to see all news.

Re: [Gambas-user] Issue 259 in gambas: When using the transformation matrix, the Draw.Picture method without Width and Height draws dot instead picture.

2012-06-27 Thread gambas
Updates: Status: Fixed Labels: -Version Version-TRUNK Comment #1 on issue 259 by benoit.m...@gmail.com: When using the transformation matrix, the Draw.Picture method without Width and Height draws dot instead picture. http://code.google.com/p/gambas/issues/detail?id=259