Hello everybody,

I have problems with local views. I'm using VFP 7.

I have opened a local view normally in my form. When I delete a record from the view (using DELETE command) and then requery the view with REQUERY() function, all the records are gone (the view is empty, which it really shouldn't be).

I can replicate this behaviour also opening view manually (command window). When I browse the base tables, the deletion is successful, the right records are deleted from the base tables. Also I can get the view result correctly when I close all the base tables and open the view again. But I can't do this when the form is active (or can I?).

The view is row buffered and there are RI triggers on delete in the view's base tables. I've checked out a couple of UT threads concerning this issue, but no help there. I have also tried to disable RI triggers and do TABLEUPDATE after DELETE as suggested in the threads, but no luck there either.

Thanks in advance,