Event on Table Update

[Dietmar Meister]

Hi

Im using ADO.NET in a WinForms database client and want to receive an event
when a row is inserted to a table of the connected database. So far I use
the data provider for Oracle or ODBC. Does anybody know if it is possible to
get an event through this interface? Or are there alternatives?

Thanks, Dietmar

 

[Kathleen Dollard]

Dietmar,

It is quite difficult. Does Oracle support triggers?

Kathleen

 

[Dietmar Meister]

Yes, a trigger on update is possible for Oracle

Dietmar

 

[Kathleen Dollard]

Dietmar,

I looked into this and didn't have to implement it, so this is theretical...

Have your filter create a file in a directory as a semaphore. The client
program can watch that directory and respond to the file.

The option is timed check from the client askign the server what's changd.

ADO.NET is a disconnected model, so there is no easy way to do what you want
to do.

Kathleen