[Gambas-user] sqlite integer to text string problem

2009-05-07 Thread Ivan Williams
Greetings I have a problem - I can query a sqlite database using SELECT ssym,sclose FROM shistory where (sdate='2009-05-06') and sclose.75 and sclose .1 order by ssym,sdate; and receive the following output: AAC|0.24 AAME|0.64 AAU|0.61 ABMC|0.16 ABTL|0.5 ACLS|0.47 but when I do the

[Gambas-user] problem with mysql

2009-05-07 Thread Adam Camp
Hi everyone, I'm running Kubuntu 9.04 (Jaunty) on an Intel P4 3GHz (i386) with 1GB of RAM. I have tried the packaged Gambas2, and have also compiled the latest from source following the instructions on the website. I am getting the following error: Cannot find driver for database: MySQL.

Re: [Gambas-user] problem with mysql

2009-05-07 Thread BenoƮt Minisini
Hi everyone, I'm running Kubuntu 9.04 (Jaunty) on an Intel P4 3GHz (i386) with 1GB of RAM. I have tried the packaged Gambas2, and have also compiled the latest from source following the instructions on the website. I am getting the following error: Cannot find driver for database: MySQL.

Re: [Gambas-user] How to input quotation mark in TextBox.Text to mysql

2009-05-07 Thread wahyu budhi
On Wed, Apr 29, 2009 at 6:48 PM, Ron r...@cyberjunky.nl wrote: webs37 schreef: Hi all, Please help.., I have error message:Query failed: You have an error in SQL syntax, check the manual that corresponds to MySQL server version for the right syntaxto use near 'an',address='Saudi

[Gambas-user] How to create xml from table view?

2009-05-07 Thread wahyu budhi
Hi all, Can I create xml from table view in gambas2? and can anyone give me an example, thx Regards, webs37 -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may

Re: [Gambas-user] How to create xml from table view?

2009-05-07 Thread Sergio A. Hernandez
I just wrote this example for a different subject. All you need to do is to encapsule the tr related lines in a external loop for each row, then you need to include the td lines in a internal loop for each column. Obviously, you can rename the style, table, tr td, elements for those you consider

[Gambas-user] Hello all :D Can anybody tell me how i can make a...

2009-05-07 Thread vlahonick vlahonick
Hello all :D Can anybody tell me how i can make a value to calculate something only if the user put specific numbers? EXAMPLE: Dim S As String Dim i, y, N, d As Integer S = TextBox1.Text y = Len(S) N = 0 For i = 1 To y d = Val(Mid(S,

Re: [Gambas-user] Hello all :D Can anybody tell me how i can make a...

2009-05-07 Thread Jesus Guardon
Hi Vlahonick You must use keycode in the keypress event to allow only selected ascii codes to be entered in your textbox: PUBLIC SUB TextBox2_KeyPress() SELECT CASE Key.Code CASE 48 TO 49 'for 1 and 0 'following cases are for allowing delete, tab, etc CASE

[Gambas-user] Hello all!!! How i can make my program to under...

2009-05-07 Thread vlahonick vlahonick
Hello all!!! How i can make my program to understand when i write c is different from cl ? EXAMPLE if textbox1.text=c then textbox1.text=1 else if textbox1.text=cl then textbox1.text=2 end if end if The problem is that when i am trying to write cl the result i get is 1l and this because the

Re: [Gambas-user] Hello all!!! How i can make my program to under...

2009-05-07 Thread Steven James Drinnan
Where are you checking this? Key press event. I would wait for another key like the return key. And then check. if key.code = key.return then if textbox1.text=c then textbox1.text=1 else if textbox1.text=cl then

Re: [Gambas-user] Hello all!!! How i can make my program to under...

2009-05-07 Thread Sergio A. Hernandez
Probably the issue here is the event in which your code is. When Gambas recognize the 'c' it changes .text to 1, that is why you are getting the 1l, What is the event you are using to perform the textbox validation? Try to change your validation code to the LostFocus() event. Probably will work

Re: [Gambas-user] How to create xml from table view?

2009-05-07 Thread wahyu budhi
On Thu, May 7, 2009 at 8:19 PM, Sergio A. Hernandez info.g...@gmail.comwrote: I just wrote this example for a different subject. All you need to do is to encapsule the tr related lines in a external loop for each row, then you need to include the td lines in a internal loop for each column.