can't CREATE TRIGGER, invalid fieldnames?? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

can't CREATE TRIGGER, invalid fieldnames??

Author

Topic

steelkilt
Constraint Violating Yak Guru

255 Posts

Posted - 2002-11-05 : 13:21:17

Can someone tell me why SQL delivers "Error 207" invalid fieldnames, when I try to create this trigger? My fieldnames are valid but the fields listed after COALESCE are tagged by SQL as invalid??

=======================================================

CREATE TRIGGER maintable_ratable

ON maintable

FOR INSERT, UPDATE

AS

IF

COALESCE (valid_fieldname1,
valid_fieldname2,
valid_fieldname3) IS NOT NULL

BEGIN

INSERT INTO valid_fieldname_4 VALUES ('R')

END

ELSE

INSERT INTO valid_fieldname4 VALUES ('NR')

steelkilt
Constraint Violating Yak Guru

255 Posts

Posted - 2002-11-05 : 13:22:20

sorry, wrong forum, will post to developer.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources