>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.


Where did you put the above code? Why using pack? TableUpdate should be used when changes to the record (delete, edit) has been made.