Information générale
Catégorie:
Codage, syntaxe et commandes
Joe,
There is *another* caveat with TABLEUPDATE(2... according to the Help. I don't know if this plays here or not, but it is that the process will *NOT* stop with an error. You should, just for your own satisfaction here, specify an array as #3 param (I think it was) and see if there is any rec# recorded there after completion.
Is this ReQuery being done in the *SAME* execution of VFP, or in some other one?
Have fun,
Jim N
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement