Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement