Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select SQL doesn't see the data changes
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01010567
Message ID:
01010659
Vues:
27
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform