i will make my aim more clearer here: i have created an AFTER insert trigger on a table called chattable which has two fields(ID INT,Message VARCHAR(255)).here is the trigger: "CREATE TRIGGER insert_trigger AFTER INSERT ON chattable REFERENCING NEW_TABLE AS chattableupdate FOR EACH STATEMENT SELECT * FROM chattableupdate" where chattableupdate is a transition table.
i want the transition table to contain the newly inserted rows whenever an insert takes place into chattable. please help me,because with this trigger,when i select * from chattableupdate and assign it to a resultset i get an error that the "chattable view/table does not exist" Bryan Pendleton wrote: > >> my problem is how to store the result of the SELECT * from table_name >> statement so that i can display it on the console output whenever ant >> data >> is inserted into the table,that data is retrieved from the table. > > It sounds like you're trying to build a sort of "audit trail", so that > you can keep track of changes to your data. > > Triggers are indeed useful for this sort of thing. > > I think one way to do this is to have your trigger capture the data > that is being inserted/updated/deleted, and inside your trigger take > that data and store it in an "audit" table. > > Then, whenever you want, you can issue normal select statements against > your audit table, and fetch the audit records of interest. > > thanks, > > bryan > > > > -- View this message in context: http://www.nabble.com/using-SELECT-as-an-SQL-triggered-action-tp15359808p15367424.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
