Hallo,
die Funktion (bzw. Sinn/Zweck) des folgenden Triggers ist mir nicht
so ganz verst�ndlich - kann mir den bitte jemand
erl�utern?
CREATE TRIGGER ADRANSPIns ON [T_ADRANSP]
FOR INSERT
AS
DECLARE @MID int
DECLARE @Adresscode varchar(1)
DECLARE @Nummer int
DECLARE @Liste int
DECLARE cIdx CURSOR LOCAL FOR SELECT Adresscode,Nummer,Liste FROM
Inserted
SET NOCOUNT ON
SELECT @MID = Mandant_ID
FROM Current_Mandant
WHERE (Tabelle = "ADRANSP") AND (Mandant_ID IS NOT NULL)
OPEN cIdx
IF @@CURSOR_Rows<>0
BEGIN
FETCH NEXT FROM cIdx INTO @Adresscode,@Nummer,@Liste
WHILE (@@FETCH_STATUS = 0)
BEGIN
UPDATE T_ADRANSP
SET Mandant_ID = @MID
WHERE (Mandant_ID = -99)
AND (Adresscode = @Adresscode)
AND (Nummer = @Nummer)
AND (Liste = @Liste)
FETCH NEXT FROM cIdx INTO @Adresscode,@Nummer,@Liste
END
CLOSE cIdx
END
DEALLOCATE cIdx
SET NOCOUNT OFF
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
