Try TABLEUPDATE(1, .T.). When you do DELETE FROM, the record pointer moves at EOF and TABLEUPDATE(.T.) only commits current row.
>Hello everyone,
>
>My issue this time is: I'm trying to delete a record from a parameterizedd remote view. I load the data in my view, then i try to delete one record from the table. I use the DELETE FROM WHERE clause and then I issue a TABLEUPDATE(.t.), then a TABLEREVERT(.t.). The remote view is included in a data environment that is loaded when the program is loaded and it is set to optimistic table buffering.
>When all this is done, the record is still there.
>
>Help, please!
>
>Josh
- Jayesh