Table Monitor

hi all...
I want to develop a VB6 module that will alert the user whenever
insert/Update happed to a table(s) ( by other user too)

I am using fb2.0.3. & ODBC

How can i able to do this with min. resource usage

Thanks in advance.

I've got no idea if there is something within Firebird itself that can monitor such things. If there isn't, that'd mean you'd have to manage it all yourself.

If that is so, one idea is to put update and insert triggers on all of your tables, so whenever one of those actions is performed, it'll save the tablename and timestamp to a new table set up for just that. Then you can query it on a regular basis to see if there are any records in this "meta" table that have a timestamp greater than the time you last checked.

Of course this would require making constant calls to the database, which seems horribly inefficient.

Another idea might be putting in insert and update triggers which make a call to a UDF (if such a thing is possible). This UDF could be tied into other parts of your system so it could trigger the sending of messages to other machines.

That's just my 2 cents.