https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/19518.aspxWed, 02 May 2007 15:43:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:19518Matt Faus0https://www.infopathdev.com:443/forums/thread/19518.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=19518Hi, <br /><br /> I think you will need to provide a little more information on your schema, both on the InfoPath and Database ends. If you are having trouble with how your database trigger is behaving I would reccommend hooking up the SQL Server Profiler so that you can watch what exactly is happening and when. This will also allow you to see any error messages that might be getting buried.https://www.infopathdev.com:443/forums/thread/16877.aspxTue, 27 Mar 2007 09:50:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16877Jibi0https://www.infopathdev.com:443/forums/thread/16877.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16877Hi<br /><br />I've a form including an extensible section wich includes a extensible array.<br />Section = Global Costs of project<br />Array = details by year<br /><br />My form is based on 2 SQL tables (global and détails) which are linked<br /><br />I create a trigger udpating a third table depending value of one field of the global table<br /><br />***********************<br />CREATE TRIGGER [InsertSatcli] ON [dbo].[CoutsINF]<br />AFTER INSERT<br />AS<br />Declare @choix bit, @id int,@NumWic nvarchar (50),@rap int,@domRap int,@com nvarchar(300),@idcouts int,@CpInfo nvarchar(50)<br />select @id = (select idlotprojet from Inserted)<br />select @idcouts=(select IdCoutsINF from Inserted)<br />select @choix = (select ValPvDef from Inserted)<br />select @NumWIc=(select NumWic from inserted)<br />select @com=(select comments from inserted)<br />select @CpInfo=(select NomCpEds from inserted)<br />select @rap=(select distinct coderap from projet,lotprojet where projet.codeprj=lotprojet.codeprj and lotprojet.idlotprojet=@id)<br />select @domRap=(select distinct CodeDomaineRAP from projet,lotprojet where projet.codeprj=lotprojet.codeprj and lotprojet.idlotprojet=@id)<br /><br />If @choix = 1 <br /> Begin<br /> insert into SatcliPrj (IdCoutsINF,NumWic,CodeRap,ValidSaisie,CodeDomaineRap,comments,CPInfo)<br /> values (@idcouts ,@NumWic,@rap,0,@domRap,@com,@CPInfo)<br /><br /> End<br />*****************<br />Pb : <br />When the trigger is not executed, global and details tables are correctly updated<br /><br />When the trigger is executed, my third table is correctly updated but not the table of details by year.<br />I've no error msg<br />it seems not continuing updating after excuting the trigger<br /><br />Thanks for help and sorry for my english<br />