Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql UPDATE() IMPOSSIBILITY
Message
From
09/12/2019 11:45:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sql UPDATE() IMPOSSIBILITY
Miscellaneous
Thread ID:
01672198
Message ID:
01672198
Views:
88
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.)
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?

Regards,
Koen
Next
Reply
Map
View

Click here to load this message in the networking platform