Protect Query Result
Date: Sun, 09 Sep 2007 22:42:32 -0700
I want to protect the result of a query. That means every database update which change the result of the quer must be discovered.
the query is
WHERE age > 50
When the connection is closed. And another app execute INSERT INTO emp (name, age) values ("asd", 60) Some warning must be issued.
In this simple case, we can write a trigger to solve it. However, in some other cases, the query is much complex (e.g there is sub-query).How to write the trigger efficiently? Is there any research topic about this area? (if yes, would you pls suggest me some keywords).
Thank in advance
AgileBall Received on Mon Sep 10 2007 - 07:42:32 CEST