If SQLGETPROP(lnConnectHandle, 'Transactions') returns 2 [manual] instead of 1 [auto-commit], then you have to use SQLCOMMIT() or SQLROLLBACK() to commit or revert your changes.

>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