Hi
I've a form including an extensible section wich includes a extensible array.
Section = Global Costs of project
Array = details by year
My form is based on 2 SQL tables (global and détails) which are linked
I create a trigger udpating a third table depending value of one field of the global table
***********************
CREATE TRIGGER [InsertSatcli] ON [dbo].[CoutsINF]
AFTER INSERT
AS
Declare @choix bit, @id int,@NumWic nvarchar (50),@rap int,@domRap int,@com nvarchar(300),@idcouts int,@CpInfo nvarchar(50)
select @id = (select idlotprojet from Inserted)
select @idcouts=(select IdCoutsINF from Inserted)
select @choix = (select ValPvDef from Inserted)
select @NumWIc=(select NumWic from inserted)
select @com=(select comments from inserted)
select @CpInfo=(select NomCpEds from inserted)
select @rap=(select distinct coderap from projet,lotprojet where projet.codeprj=lotprojet.codeprj and lotprojet.idlotprojet=@id)
select @domRap=(select distinct CodeDomaineRAP from projet,lotprojet where projet.codeprj=lotprojet.codeprj and lotprojet.idlotprojet=@id)
If @choix = 1
Begin
insert into SatcliPrj (IdCoutsINF,NumWic,CodeRap,ValidSaisie,CodeDomaineRap,comments,CPInfo)
values (@idcouts ,@NumWic,@rap,0,@domRap,@com,@CPInfo)
End
*****************
Pb :
When the trigger is not executed, global and details tables are correctly updated
When the trigger is executed, my third table is correctly updated but not the table of details by year.
I've no error msg
it seems not continuing updating after excuting the trigger
Thanks for help and sorry for my english