>The main issue here is that I use the view to update the respective tables. So everytime I mark a record for deletion on the view, it updates it on the tables. But when I run the view again, the records come as unmarked on the view, but still marked on the tables. How do one make the view know and show that the record is marked for deletion on the table. Using SET DELETE ON/OFF specifies whether Visual FoxPro processes records marked for deletion and whether they are available for use in other commands.
Hi,
I've just recently read the related discussion in VFP Russian club. Apparently it's a confirmed and still unresolved bug. In order to show deleted records in a view, you have to mark them for deletion again, e.g. delete where key_ID in (select key_id from myTable where deleted())
If it's not broken, fix it until it is.
My Blog