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

If you're using 5.0, the 1st parameter to tableupdate() should be a number as this has an impact on whether you have table or row buffering set. It's been a long time since I used 3.0 and .T. as a 1st parameter and can't remember.

Steve