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