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.