Here's my dilemma...
I have two applications running at the same time. One of them updates a table. When the other application reads the updated data, it doesn't see the modified data (initially).
Background:
We are using the default cursorsetprop(), which would set row and table buffering off. Because of this, I can not use the TableUpdate() function.
What I have found to work:
If I close and reopen the table, the reading app gets the appropriate data. From the command window, I can even change the cursorsetprop to "Buffering", 5 (or some other "Buffering" state), then set it back to "Buffering", 1 -- and have the reading app get the appropriate data. In code, this does not work without substantial pauses between setting the two states.
Has anyone else found a better solution... or even run into this problem?
Thanks in advance.