Re: Q: Callback (notification) with ODBC?

From: <toffie_at_my-dejanews.com>
Date: Thu, 28 Jan 1999 12:49:30 GMT
Message-ID: <78pmco$2q7$1@nnrp1.dejanews.com>

In article <36AF2D6E.A948EED1_at_nist.gov>, Omer Eisenberg <omereis_at_nist.gov> wrote:
> Hi All,
> I'm writing a client-server application under NT with VC++ and MFC,
> using ODBC interface to Oracle.
> I would like the client software to be notified when some tables are
> changed. Can anyone please let me know how it is done?
> Thanks in advance,
> Omer.
>

ODBC is not equipped to do this.. you can get this functionality easily via workarounds though: Try checking the db system tables to verify when was the last time that a certain table was updated, had an insert, had an delete. You could also create a trigger on an insertion, deletion or update which would update a helptable with a timestamp. This table could be queried by ODBC periodically...

Toffie.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 28 1999 - 06:49:30 CST