tracking changes on a table through ODBC application

I have a table in which users are inserting records almost all the time. I need to write an ODBC based application program that would allow me to see what data is being inserted into the table in real time.

One idea is to run a select query on the table (select * from table) once, keep the resultset open throughout the lifetime of the application, and then do SQLFetch() to get each new row that has been inserted into the table.

My question is weather it is possible to keep the resultset open and see changes from other users in that result set. Can this be done using a cursor?

Thanks Received on Wed Jul 16 2003 - 20:18:42 CDT