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

Is it possible curNAW is at end of file?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Reply
Map
View

Click here to load this message in the networking platform