VFP 9

I have a form with the following code

SELECT pireq 
DELETE FROM pireq WHERE creqno = lcreqno
BROWSE
SELECT piitems
DELETE FROM piitems WHERE creqno = lcreqno
BROWSE  	

when browing the tables from within the form method the records are marked as deleded, but when I view the same records from the "data" tab of the project manager they are not marked as deleted.

The dataenviorment is set to private and optomistic. For the tables I have bufferoveride set to optomistic and a filter, and an order set.

Why? Any help appreicatied.