I would do something like:

set multilocks on
use userproj
= CURSORSETPROP('Buffering', 5, 'userproj')

lccom=[Update userproj set userid = ']+thisform.mastertableid+;
[' where projno = ']+thisform.text1.value+;
[' and workpkg = ']+thisform.text2.value+[']
&lccom

?tableupdate(.T.)

Regards


>I want to use the following query.
>
>Update userproj set userid = thisform.mastertableid
>where projno = thisform.text1.value
>and workpkg = thisform.text2.value
>
>Could you please tell me how i can use the above query inorder to update the records in the table.
>
>**************
>i always do this in order to create a new record.
>
>select userproj
>replace projno = thisform.text1.value
>= tableupdate(.t.,.t.)
>
>******************
>
>
>Thank you.