RE: triggers
Ok Art. I'll will take a look on that. Thanks!
Met vriendelijke groeten / Sincères salutations / Kinds regards,
Danny De Koster
FIDELITY SOFT nv
Cardijnstraat 5
1980 Eppegem
Tel: 015/618.270
Fax: 015/616.052
-----Oorspronkelijk bericht-----
Van: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Namens Art Kagel
Verzonden: woensdag 17 maart 2010 22:20
Aan: ids@iiug.org
Onderwerp: Re: triggers [19354]
Do the testing and inserting in a stored procedure and call the
procedure/function from the ON EVERY ROW clause in the trigger. If you have
a later release of IDS you can define the routine as a "trigger routine"
then the NEW record will be available in the procedure/function without
explicitely passing in the columns:
create function check_and_insert_a_copy() referencing NEW as latest fortable1 returning int;
.....
end function.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, Mar 17, 2010 at 5:08 PM, DANNY DE KOSTER <ddk@fidelity-soft.be>wrote:
> Hi all,
>
> I need some tips about triggers and inserting something in a table on
> condition.
> I created a trigger:
>
> create trigger trig1
> insert into table1 referencing new as new>
> for each row(
>
> select from table2 where table2.id = new.id
>
> if table2.xx = 1 then
>
> insert into table3 values(xx)>
> end if
>
> );
>
> So I would like to test something in the trigger before I write something
> in a
> table. Is that possible??
>
> thanks for any tips!
> Danny
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001517588b7a5f0006048205ac28
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.