Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering and Tableupdate()
Message
 
To
13/04/2006 11:41:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01113462
Message ID:
01113477
Views:
17
>If the controls on a form display and operate on data contained in a temporary cursor, how do you save the revised data back into the original table? I'm experimenting with the following code sequence to try and figure this out but I can't seem to get it right.
>
>
>select * from test_financing into cursor crstemp readwrite
>set multilocks on
>=cursorsetprop("buffering",5,"test_financing")
>select crstemp
>go top
>replace amount with 2000
>=tableupdate()
>
>
>Any help will be appreciated.

Use CursorAdapter or Updatable Local View for this.
I suupose this is only an example of what you want to do, but if you do this in a regular bases you must consider using LV or CA. That will make you life easier :o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform