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


Hi,

I have managed to deal with this problem. After deletion of a record in a local view, in order to requery the view with REQUERY() function, you must re-select the view i.e.:

&& the view is selected now
DELETE
&& the view is still selected, but requerying without selecting again after && deletion will result an empty view
&& so let's first re-select it
SELECT view

REQUERY()
&& view requeried successfully

Quite simple solution to a problem that gave me quite a lot of headache... :)