Re: tracking changes on a table through ODBC application

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Thu, 17 Jul 2003 03:09:09 GMT
Message-ID: <proRa.79962$N7.9538@sccrnsc03>

"db dude" <db_guy_2002_at_yahoo.com> wrote in message news:f4a8da28.0307161718.395202f7_at_posting.google.com...
> 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

You aren't going to see the data until they commit.(and you reexecute the query)

What problem are you trying to solve? We might be able to suggest something more fitting.
Jim Received on Wed Jul 16 2003 - 22:09:09 CDT