If these two values are constants, just use them directly in your update (no need to use FROM CLAUSE at all). Or simply use replace command.

>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