Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Writing to / Reading from a table
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00148309
Message ID:
00148310
Views:
20
Try issuing an FLOCK(), then UNLOCK in the reading application. Or, if you just want to update the data in an existing record you can use RLOCK().

>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform