Hi Steve,
>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?
It sounds like changes have been made to the view and it is not closing/requerying. Is your grid readonly? If you don't want to keep any changes you could also issue a TableRevert() on the view at unload.
HTH,
Bill Armbrecht
VFP MCP