Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REQUERY bringing back pre TABLEUPDATE values??
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
REQUERY bringing back pre TABLEUPDATE values??
Miscellaneous
Thread ID:
00050576
Message ID:
00050576
Views:
72
Here's the scenario..

I've got a view on a table...

I do a CURSORSETPROP("Buffering", 3) on it...

I change some values in the view

I do a TABLEUPDATE(2, .T.)

2 means write all records if table buffering or just the current if record buffering (says the manual)
.T. means force the changes even if the data in the record has changed

Now I can look at the view AND at the source table and BOTH are the same and reflect the NEW values.

Now here's the tricky part...I am using this view to populate a grid so whenever the grid is refreshed I make sure to do a REQUERY.

Now the instant I do the REQUERY I notice that my values in my view GO BACK to what they were originally!!!
And my actual table on disk STILL has the correct, new values!


HELP!!!!!!

I've been doing this for hours, and I've finally narrowed it down to this..

But this seems...impossible...

Thanx
Independant Foxpro Developer
Spring Hill, FL
jpirola@tampabay.rr.com
352/686-8373
Next
Reply
Map
View

Click here to load this message in the networking platform