Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
REQUERY bringing back pre TABLEUPDATE values??
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
REQUERY bringing back pre TABLEUPDATE values??
Divers
Thread ID:
00050576
Message ID:
00050576
Vues:
74
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform