>
>>>What is the status of SET DELETED
in both cases? (Maybe do a Wait Window Set("Deleted")
to find out). Remember that it is scoped to the data session.
>>>
>>>Set Deleted is ON
>>
>>Is ON for both cases, command window and form with grid>
>Are you sure? Did you add the Wait Window (or used the debugger) just before you requery() the view to make sure? Does the View contain "For Not Deleted()"? (this also may or may not be an issue on optimization, depending on various factors).
I found out what was happening. I have a form class where in load method I issue set deleted on.
The form where the view is placed is based on this form class. In the environment of the form I defined the view with noDataOnload = .F.
So, in this case the view does not respect the command Set Deleted On present on load method of the form.
What I did?
I set nodataonload = .T. in the environment of the form and
=requery('myview') in the init method.
Antonio Carlos Kleinübing
Systems Analyst