Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can VFP clear tables used by ODBC?
Message
De
22/01/2003 08:08:39
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
 
 
À
22/01/2003 01:38:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00744135
Message ID:
00744186
Vues:
16
Have you tried TABLEUPDATE() and SQLCOMMIT() ?

If table buffering is set to 5 , you must execute TABLEUPDATE() for your changes to be saved .


>Hi All,
>
>I have an SQL View in my database which I am running a select on through SQLEXEC. Now the select works perfectly, however if I update my data in the table that the SQL View is looking at and re-run the select the data doesn't seem to update in the view until I SQLDisconnect(). Is there anyway to clear all the data being used by the ODBC driver without having to disconnect from my connection?
>
>thanks,
>
>Michael Henstock
>AWS
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform