Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want to update the record
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00669400
Message ID:
00669418
Views:
11
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform