This trigger works create but I also need it to set things the other way and
I don't know they syntax.
CREATE Trigger open_closed ON dbo.Courses
After UPDATE
AS
UPDATE dbo.courses
Set open_closed=0
where dbo.courses.course_count> dbo.courses.maximum
I want it to also deal with this.
Set open_closed=1
where dbo.courses.course_count< dbo.courses.maximum
Thanks
--
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
