Below are the details of the trigger. If I insert into the triggering table outside of Baan everything works fine. When using the app I get bdb_errno 2260.

Anyone got any ideas?

Thanks

Mark

My Trigger
-----------------
create trigger ttssma310110_i_trg
update on ttssma310110
referencing new as new
for each row
(insert into ttsvco310110
(ttsvco310110.t_orno,
ttsvco310110.t_seqn,
ttsvco310110.t_trdt,
ttsvco310110.t_ntime,
ttsvco310110.t_amta,
ttsvco310110.t_refcntd,
ttsvco310110.t_refcntu,
ttsvco310110.hash1)
values (new.t_orno, new.t_seqn, TODAY, CURRENT, new.t_amta, 0, 0,
CURRENT));

My new table ttsvco310110
--------------------------------
key is ntime(transaction time)
ideally I want a combination or orno,seqn,date ,time since 1st 3 fields can be same for multiple records

Column name Type Nulls

t_orno integer no
t_seqn smallint no
t_trdt date no
t_ntime integer no
t_amta float no
t_refcntd integer no
t_refcntu integer no
hash1 char(17) no


Old table on which trigger ttssma310110

Column name Type Nulls

t_orno integer no
t_seqn smallint no
t_cprj char(6) no
t_tcst smallint no
t_ctpg char(3) no
t_revi char(6) no
t_date date no
t_emno integer no
t_ccar char(10) no
t_tano smallint no
t_item char(16) no
t_citm char(16) no
t_cser char(20) no
t_olit char(16) no
t_olcs char(20) no
t_cwar char(3) no
t_cvat char(9) no
t_cpcp char(3) no
t_camp float no
t_camn float no
t_qanp float no
t_qana float no
t_aqan float no
t_oqan float no
t_iqan float no
t_cuqs char(3) no
t_cvqs float no
t_cups char(3) no
t_leng float no
t_widt float no
t_thic float no
t_cvps float no
t_pric float no
t_cgua char(3) no
t_gdat date no
t_iper smallfloat no
t_gper smallfloat no
t_cper smallfloat no
t_cada date no
t_disc smallfloat no
t_ldam float no
t_amta float no
t_scos smallint no
t_repl smallint no
t_bhra smallint no
t_invn integer no
t_ttyp char(3) no
t_invd date no
t_ncmp smallint no
t_**** integer no
t_ppon smallint no
t_prnt smallint no
t_itxt integer no
t_ccty char(3) no
t_txam_l float no
t_refcntd integer no
t_refcntu integer no
hash1 char(8) no
hash2 char(13) no
hash3 char(19) no
hash4 char(24) no
hash5 char(14) no
hash6 char(24) no