Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Param views not updating properly in 2 separate exes
Message
De
22/07/1999 16:07:28
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00244820
Message ID:
00244962
Vues:
18
>Two separate machines bring up the same form using a parameterized date-range view. After one user on Machine A adds a record and saves it. Machine B then closes the form and reopens the form, but the added record doesn't show.
>
>Has anyone seen this kind of behavior before?
>
>I'm implementing an odd work around. When the form first opens I force a change by replacing one of the views fields with itself and then tableupdate the view. After this I call the requery. For some reason I can now see the other record.
>

I take it you have "Changed fields only" as the update type in your view definition? If you change this to "key fields" you won't need to do that silly replace before you do a TABLEUPDATE().

Are you surethat Machine A is doing a TABLEUPDATE()? Are you sure the TABLEUPDATE is successful?
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform