Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Help With Table Buffering/TABLEUPDATE()
Message
From
04/05/1998 13:54:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Need Help With Table Buffering/TABLEUPDATE()
Miscellaneous
Thread ID:
00096788
Message ID:
00096788
Views:
74
Hi to All
I am having trouble deleting multiple records from a grid using a temporary table. I set the MULTILOCKS ON before I atempt to do any updating, then select the records I want to delete from the grid. To finish up I issue a =TABLEUPDATE(.T.) which I thought would commit the changes to the table. Unfortunatly when I move to the next record that I want to delete items from, FoxPro says that the "Record is in use by another user". Then I get "Buffer contains Uncommited Changes"
Here is my code:

USE TEMPDED
SET MULTILOCKS ON

=cursorsetprop('buffering',2,'tempded') && commit changes to record.
=TABLEUPDATE(.T.,.T.,'tempded')
=cursorsetprop('buffering',1,'tempded') && turn off buffering

PACK
SET SAFETY ON

=THISFORM.mygridrefresh()
I have tried using a 5 in the first cursorsetprop but it doesn't seem to help. Can anyone help me with this. Thanks alot.
Next
Reply
Map
View

Click here to load this message in the networking platform