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.