Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why am I not getting the updated value?
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why am I not getting the updated value?
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01055530
Message ID:
01055530
Views:
49
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.
Next
Reply
Map
View

Click here to load this message in the networking platform