General information
Category:
Coding, syntax & commands
Title:
Need Help With Table Buffering/TABLEUPDATE()
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only