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

Click here to load this message in the networking platform