Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering and Tableupdate()
Message
From
13/04/2006 12:21:20
Mike Yearwood
Toronto, Ontario, Canada
 
 
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:
01113492
Views:
15
>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.

Views are not as flexible as SPT. Either use the CursorAdapter or alter your cursor to make it update the base tables. Use CursorSetProp to set the KeyFieldList, Tables, UpdatableFieldList, UpdateNameList, WhereType, SendUpdates and Buffering and do a tableupdate.
Previous
Reply
Map
View

Click here to load this message in the networking platform