Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Bruce
On Fri, 2014-02-14 at 11:28 +0100, Roel Touwen [prive] wrote: > Hi Bruce, > > That is indeed from the email-wrapping. That part works fine. I get the > data from the database. > > The Sql what is sent to MySql is: > *relation = '9123' and robotID = 1 and rectype = 'TS' and subID = '' and > sequ

Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Fabien Bodard
If I remember well there is a way to get all the underlayer output. On the project option in environment tab there is a buttonmenu with known special env value. Look if there Is a sql one (I'm not on my pc) Le 14 févr. 2014 11:30, "Roel Touwen [prive]" a écrit : > Hi Bruce, > > That is indeed fr

Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Roel Touwen [prive]
Hi Bruce, That is indeed from the email-wrapping. That part works fine. I get the data from the database. The Sql what is sent to MySql is: *relation = '9123' and robotID = 1 and rectype = 'TS' and subID = '' and sequencer = 0* But, as said, that part works. op 14-02-14 11:23, Bruce schreef:

Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Bruce
On Fri, 2014-02-14 at 10:54 +0100, Roel Touwen [prive] wrote: > Sql = "relation = '" & Main.RobotCust & "' and robotID = " & > Main.RobotID & " and rectype = 'TS' and subID = '' and sequencer > = 0" After that line can you print (or debug) Sql. Don't know (because of email wrapping) but it lo

Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Roel Touwen [prive]
Hi Fabien, Uptil the .update it works. I get the record, I can read the data and after setting the field it contains the new data. Strangest thing is that there is no error. The program assumes it has updated the record. But in the db the update is not performed. op 14-02-14 10:47, Fabien Bo

Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Fabien Bodard
When you say won't work.. does it crash ? Do you obtain the edit result object ? Is result.available is true Le 14 févr. 2014 10:20, "Roel Touwen [prive]" a écrit : > I tried that but it isn't the solution. > > In the past I tried combining gambas2 and gambas3 on fedora 18. I had > the same situa

Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Roel Touwen [prive]
I tried that but it isn't the solution. In the past I tried combining gambas2 and gambas3 on fedora 18. I had the same situation then but I blamed it on the combination of g2 and g3. Now I installed it on a clean fedora 20 machine and I experience the same. op 14-02-14 10:15, Fabien Bodard sc

Re: [Gambas-user] Strange msq problem

2014-02-14 Thread Fabien Bodard
And If you add db.commit at the end of the job ? Le 14 févr. 2014 10:04, "Roel Touwen [prive]" a écrit : > Hi All, > > I have installed the latest Fedora (20) with gambas from the repository. > > When I do some datathing in mysql it simple won't update the database. > > This code works fine on my

[Gambas-user] Strange msq problem

2014-02-14 Thread Roel Touwen [prive]
Hi All, I have installed the latest Fedora (20) with gambas from the repository. When I do some datathing in mysql it simple won't update the database. This code works fine on my old gambas 2 but update won't work in gambas3: Public Sub SendTimeStamp() Dim Hs As String Hs = "Test" Sq