Re: SQL Trigger Body using "CLASS"

I have the following body to a trigger. It doesn't work anymore. "CLASS"
is now a reserved word. I have "CLASS" as a field name (column name) in all
the tables involved in the trigger body. Any ideas how I can make this work
without changing the field name in all the tables? The trigger is after
insert on workpiececlasscolumns.


BEGIN ATOMIC
DELETE FROM RJSFLOW . WORKPIECECLASSCOLUMNSLINKED WHERE RJSFLOW .
WORKPIECECLASSCOLUMNSLINKED . CLASS = NEW_ROW . CLASS ;

INSERT INTO RJSFLOW . WORKPIECECLASSCOLUMNSLINKED ( CLASS , N1 , N2 , N3 )
( SELECT CLASS . CLASS , N1 . NEXTVALUENAME , N2 . NEXTVALUENAME , N3 .
NEXTVALUENAME FROM RJSFLOW . WORKPIECECLASS CLASS
LEFT JOIN RJSFLOW . WORKPIECECLASSCOLUMNS N1 ON CLASS . CLASS = N1 . CLASS
AND N1 . VALUENAME = ''
LEFT JOIN RJSFLOW . WORKPIECECLASSCOLUMNS N2 ON CLASS . CLASS = N2 . CLASS
AND N2 . VALUENAME = N1 . NEXTVALUENAME
LEFT JOIN RJSFLOW . WORKPIECECLASSCOLUMNS N3 ON CLASS . CLASS = N3 . CLASS
AND N3 . VALUENAME = N2 . NEXTVALUENAME
WHERE CLASS . CLASS = NEW_ROW . CLASS ) ;
END


______________________________________________________________________________________________________________
Dan Kimmel | Workflow Guru | RJS Software Systems
2970 Judicial Road, Suite 100 | Burnsville, MN 55337 | *: 952-736-5800 | *:
dkimmel@xxxxxxxxxxxxxxx<mailto:dkimmel@xxxxxxxxxxxxxxx>
[cid:907235719@05022013-183D]<http://www.rjssoftware.com/

[cid:907235719@05022013-1844]<mailto:http://

blogs.rjssoftware.com/rjsinformer/index.php/feed/

[cid:907235719@05022013-184B]<

http://www.facebook.com/?ref=home#!/pages/RJS-Software-Systems/124687644237867?ref=ts

[cid:907235719@05022013-1852]<http://twitter.com/rjssoft
[cid:907235719@05022013-1859]<

http://www.linkedin.com/companies/rjs-software-systems

[cid:907235719@05022013-1860]<

http://www.youtube.com/user/RJSSoftwareSystems>
Manage the entire lifecycle of your business information


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.