Turn off disk write caching on the server? What is the DB? VFP? SQL Server? Other?
>Hi everybody,
>
>I'm running into the problem, where Select SQL doesn't see updates.
>
>Here is the scenario:
>
>One form with private DS calls another very complex form with private DS. The user makes changes on the second form. As long as changes saved, the first form should be refreshed. Originally I was using views and everything worked. I switched to using direct select sql commands and now my data are not refreshed properly. However, then I close the first form (the whole application) and re-start it, I see data refreshed.
>
>What can I do to rectify the problem? We're going to switch to VFP9 in few days, but presently we're working with VFP8.
>
>Thanks in advance.
Mark McCasland
Midlothian, TX USA