Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why am I not getting the updated value?
Versions des environnements
Been a while since I've had an issue, sorry for my absence.
anyway, I've got A program which runs through a load of code on a timer if it finds a file it starts a dcom object and calls a function, this function sets a field in a remote view to .F. does a tableupdate() and returns
my understanding is that a call to a dcom object is like a standard function call, that it must complete for control to return.
also that by doing a tableupdate() my base table will have been updated, however in the main program after the function as returned I do a requery() on it's remote view and the value is still .T.
if I go into debug and step through slowly it's is .F. by the time I get to it.
how can I force things to fully update?
I've tried a use and flush in the dcom object before returning the function but still no luck.
hope I'm making sense, this has been sending me nuts today.
!! update !! In the main program I did a use of the remote view after getting back from the function and reopened it, then did a requery() (not sure if that was neccessary) and it's working as I expect, but why?
Ken.
Suivant
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