Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Refreshing Problem
Message
 
To
12/07/2000 17:41:45
Steve Summers
Pima County Superior Court
Tucson, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00391562
Message ID:
00391608
Views:
10
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform