I'm having a problem with a parameterized local view. This view is not complex, it basically orders child data by date. The view is bound to a grid on a form. The problem is as follows. The user selects a parent record and the RSN (Primary key) is stored on my application object. Then the user opens the form the first time and all works fine. They close the form (the view is closed in the unload event) and select a new parent. When they open this form for the second time, the child data from the previous parent is displayed. This does not happen all the time which makes this problem even more frustrating. The form with the view has the following code in the load event.
*-- Set view parameter
vwkey = poapp.defid
If used("vwaddresses")
select vwaddresses
else
select 0
use vwaddresses nodata
endif
requery()
The database is located across a WAN and resides on a Novel Server. Has anyone experienced this behavior before?
Thanks in advance or I hope this helps!
[STS]
:>