Hi Dan
I think you might want to run your trigger after an insert (assuming
that each sign-up creates a transaction) Once the insesrt is done, run a
query that compares the total registrations to the maximum allowed, then
fire your trigger when the registration equals the maximum.
Here is an example of an insert trigger, that shows the proper syntax
of a insert trigger:
CREATE TRIGGER lentest ON [dbo].[ctaContacts]
after INSERT
AS
update dbo.ctacontacts
set customfield1 =
ltrim(str(Datepart(yy,ctaContacts.DateCreated))+'00190083'+ltrim(str(ctacontacts.recordkey)))
FROM inserted
where dbo.ctacontacts.recordKey=inserted.recordkey
Regards,
Len Wright
Plus International Corp
www.plusinternational.com
Direct: 604-415-2384
Fax:604-415-0830
>>> [EMAIL PROTECTED] 05/17/02 12:26PM >>>
I need to know the correct Syntax for this trigger. I'm pretty new at
this
one.
CREATE TRIGGER [Close_Course] ON [dbo].[Courses]
FOR UPDATE
AS
IF UPDATE (Course_Count)
Set Open_Closed='Closed'
Where Course_Count > Maximum
What happens is everytime someone registers for a course it increments
the
course_count. When it is greater than the Maximum I want the column row
to
change to Closed.
Dan
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
215-799-0192
610-256-2843
Fax 413-410-9682
FMP,Tango, EDI,SQL 7
[EMAIL PROTECTED]
www.dss-db.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to
[EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
