>>Hi,
>>
>>I have following code in myForm.Updating method:
>>
>>Select curNAW
>>liID = Id
>>Update NAW ;
>> SET ;
>> NAW.Voornaam = curNAW.Voornaam , ;
>> NAW.geslacht = curNAW.geslacht ;
>> FROM curNAW ;
>> where NAW.Id = m.liID
>>m.llSuccess = Tableupdate(.F.,.T., "naw")
>>
>>
>>curNAW.Voornaam value = "Koen"
>>m.liID =149
>>there exsists a NAW.ID = 149
>>nevertheless after this update, NAW.Voornaam = [ ]
>>
>>now when I copy this command to a testsql.prg and run that, it works as it should.
>>I am overasked where to look to correct my method, any idea's?
>
>Look at the tableupdate... try with the third parameter. Without it, it works on the current alias which, as I see the code, is not the alias to which you issued the update statement.
Dragan,
My update statement:
m.llSuccess = Tableupdate(.F.,.T., "naw")
it is naw.dbf which is the alias to which the update statement is issued.
again the exact code works fine in .prg file
When I issue the debugger and set a breakpoint right on the tableupdate( ) I can see naw.voornaam = [ ], so also after this tableupdate( ) it will remain empty not?
Have checked my Data Sessions, only 1 running.
Mystery.
Koen