Hallo, folgender Trigger: CREATE TRIGGER trig_InvoiceAmount ON dbo.tblInvoices FOR INSERT, UPDATE
AS DECLARE @intID int SELECT @intID = lngCOMCommID FROM inserted UPDATE [tblCommissions] SET [tblCommissions].[fltCOMCommInvcAmnt] = (SELECT SUM(fltINVInvoiceAmount) FROM [dbo].[tblInvoices] WHERE [tblInvoices].[lngCOMCommID] = @intID) WHERE [tblCommissions].[lngCOMCommID] = @intID /* Teil 2*/ DECLARE @myID int, @myDate smalldatetime, @netCashDays int SELECT @myID = lngCOMCommID, @myDate = dtmINVInvoiceDate, @netCashDays = intINVNetCashDays FROM inserted UPDATE [tblCommissions] SET [tblCommissions].[sdtCOMCommLstInvcDate] = @myDate, [tblCommissions].[sdtCOMCommLstPmntDate] = (DATEADD(Day, @netCashDays, sdtCOMCommLstInvcDate)) WHERE [tblCommissions].[lngCOMCommID] = @myID F�hrt den 2. Teil nur bei UPDATE aus, nicht aber bei Insert. Woran k�nnte das liegen? Gruss Alex www.aspintranet.de ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
