[Gambas-user] Strange msq problem

[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 Bodard schreef:
> 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]" <roel at ...3306...> 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 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 schreef:
>>> And If you add db.commit at the end of the job ?
>>> Le 14 févr. 2014 10:04, "Roel Touwen [prive]" <roel at ...3306...> 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 old gambas 2 but update won't work in
>> gambas3:
>>>> Public Sub SendTimeStamp()
>>>>     Dim Hs As String
>>>>
>>>>     Hs = "Test"
>>>>
>>>>
>>>>       Sql = "relation = '" & Main.RobotCust & "' and robotID = " &
>>>> Main.RobotID & " and rectype = 'TS' and subID = '' and sequencer = 0"
>>>>       rsTimeSt = db.Edit("robots", Sql)
>>>>       rsTimeSt!msg = Hs
>>>>       rsTimeSt.Update()
>>>>     Endif
>>>>
>>>>
>>>> End
>>>>
>>>>
>>>>
>>>>
>> ------------------------------------------------------------------------------
>>>> Android apps run on BlackBerry 10
>>>> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>>>> Now with support for Jelly Bean, Bluetooth, Mapview and more.
>>>> Get your Android app in front of a whole new audience.  Start now.
>>>>
>>>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
>>>> _______________________________________________
>>>> Gambas-user mailing list
>>>> Gambas-user at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>>>
>> ------------------------------------------------------------------------------
>>> Android apps run on BlackBerry 10
>>> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>>> Now with support for Jelly Bean, Bluetooth, Mapview and more.
>>> Get your Android app in front of a whole new audience.  Start now.
>>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Gambas-user mailing list
>>> Gambas-user at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Android apps run on BlackBerry 10
>> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>> Now with support for Jelly Bean, Bluetooth, Mapview and more.
>> Get your Android app in front of a whole new audience.  Start now.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
> ------------------------------------------------------------------------------
> Android apps run on BlackBerry 10
> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
> Now with support for Jelly Bean, Bluetooth, Mapview and more.
> Get your Android app in front of a whole new audience.  Start now.
> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user