Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Non-refreshing view
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Non-refreshing view
Divers
Thread ID:
00551148
Message ID:
00551148
Vues:
41
I probably don't fully understand how views work in VFP but I have a strange problem I have to solve.

One of my VFP5 program almost exclusively uses views and it's giving wrong info. Check the following:

WAIT WINDOW STR(vOrder.adminfee,10,2) && gives 0.00 (incorrect)
WAIT WINDOW STR(vOrder.markup,10,2) && gives 0.00 (incorrect)
SELECT vOrder
BROWSE && I see the record with $500 for adminfee and 15 for markup
WAIT WINDOW STR(vOrder.adminfee,10,2) && gives 500.00 (correct)
WAIT WINDOW STR(vOrder.markup,10,2) && gives 15.00 (correct)

So I tried to requery the view just before but it's still wrong.

nCampID = 5 && parameter
nCustID = 20 && parameter
= REQUERY("vOrder")
WAIT WINDOW STR(vOrder.adminfee,10,2) && gives 0.00 (incorrect)
WAIT WINDOW STR(vOrder.markup,10,2) && gives 0.00 (incorrect)
SELECT vOrder
BROWSE && I see the record with $500 for adminfee and 15 for markup
WAIT WINDOW STR(vOrder.adminfee,10,2) && gives 500.00 (correct)
WAIT WINDOW STR(vOrder.markup,10,2) && gives 15.00 (correct)

It's like unless I BROWSE the record it doesn't get refreshed. What's wrong? TIA.
It's "my" world. You're just living in it.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform