after update trigger

[jamert]

Hi, i've confused with triggers, still trying to wrap my head around the logic syntax, belowis what i have wich isn't working. when clientportal db table [_Info] gets an insert to take the autoIncrementing MemberID and insert it into db clientportalforms.dbo.mcpage1 in a column called MemberID.

what am i doing wrong?

ALTER TRIGGER [ClientPortalForms].[dbo].[InsertMCforms]
ON [ClientPortal].[dbo].[_Info]
AFTER INSERT
AS
BEGIN
UPDATE [ClientPortalForms].[dbo].[MCPage1]
SET [ClientPortalForms].[dbo].[MemberID] = [ClientPortal].[dbo].[MemberID]
FROM [ClientPortalForms].[dbo].[MCPage1], inserted
WHERE [ClientPortalForms].[dbo].[MCPage1].[MemberID] = inserted.MemberID
END

 

[bborissov]

If you want to INSERT

and insert it into db clientportalforms.dbo.mcpage1 in a column called MemberID

than INSERT it, not UPDATE.

ALTER TRIGGER [ClientPortalForms].[dbo].[InsertMCforms]
ON [ClientPortal].[dbo].[_Info]
AFTER INSERT
AS
BEGIN
   INSERT INTO [ClientPortalForms].[dbo].[MCPage1] (MemberId)
   SELECT [MemberID] FROM inserted
END

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP