Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Non-refreshing view
Message
From
30/08/2001 18:22:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Non-refreshing view
Miscellaneous
Thread ID:
00551148
Message ID:
00551148
Views:
42
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.
Next
Reply
Map
View

Click here to load this message in the networking platform