Øystein Grøvlen wrote:
I do not think doing a select in a trigger does not make sense.
Sorry, to many negations here. I mean of course that "doing a select in
a trigger does not make sense".
JDBC
does not provide you with any way to get hold of the result set.
From your description, I think
musky wrote:
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 S
musky <[EMAIL PROTECTED]> writes:
> somebody please help me here please!!
> please!!
> its urgent...
Please see
http://www.catb.org/~esr/faqs/smart-questions.html#urgent
>
> musky wrote:
>>
>> i will make my aim more clearer here:
>> i have created an AFTER insert trigger on a table called cha
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-tp15359808p15425114.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
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.
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 t
enever ant data
is inserted into the table,that data is retrieved from the table.
is such a thing possible.
urgent help needed please.
--
View this message in context:
http://www.nabble.com/using-SELECT-as-an-SQL-triggered-action-tp15359808p15359808.html
Sent from the Apache Derby Users ma
