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