Thanks, Alan and Helen.

I searched for all the possible SQL triggers and update commands and
could not find anything special.

Then I found that the "extra" records appear at some specific time ,
like mostly at the seconds 1 and 31.

It turns out I have an extra C routine that updates one field of
table A and this routine runs under a cronjob that run every N*30
seconds. :-)

Vu

--- In firebird-support@yahoogroups.com, "vuqpham" <vuqpham@y...>
wrote:

> I create a trigger on table A so that whenever A is updated, some
> information from A ( and other tables ) will be created on B.
>
> For some reason, one update on A sometimes creates two or three
> records on B. The first time is when A is updated, and the 2nd (

and

> 3rd ) is 2 or 3 minutes after that.
>
>
>
> The trigger is as follows :
> set term !! ;
> create trigger currinsp_updcon_update for currinsp
> after update as
> declare variable projectnumber char(12);
> declare variable insid char(3);
> BEGIN
> if( EXTRACT( HOUR from NEW.CIS_DATE ) <> 0 OR EXTRACT(
> MINUTE from NEW.CIS_DATE ) <> 0 ) THEN
> BEGIN
> select wks_projkey,ins_id from wksheets JOIN
> inspectors on wks_insfk=ins_pk where wks_pk = OLD.CIS_WKSFK
> into :projectnumber,:insid;
> insert into projectupdate ( upd_proj, upd_inspcode,
> upd_status, upd_datetime, upd_insid, upd_debugcode, upd_nowtime,
> upd_fk ) values ( :projectnumber, OLD.CIS_CODE, NEW.CIS_STATUS,
> NEW.CIS_DATE, :insid, 1, CURRENT_TIMESTAMP, OLD.CIS_PK );
> END
> END !!
> set term ; !!
>
>
> ( The field upd_nowtime is for debugging. It shows the repeated
> records are created 2 or 3 minutes after the first one is created )
>
> Any advice is greately appreciated.
>
> Thanks,
>
> Vu