Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Refreshing Problem
Message
 
À
12/07/2000 17:41:45
Steve Summers
Pima County Superior Court
Tucson, Arizona, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00391562
Message ID:
00391608
Vues:
11
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform