General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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... :)
Hi Tapani,
Could you provide complete repro code that demonstrates the problem?
Thanks,
Aleksey.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only