Re: Newbie Trigger Syntax

"Forrest Cicogni" <fcicogni_at_sageasset.com> wrote in message news:<1007147926.537486_at_news>...

Thanks for your help, Forrest.
I ran your code, and it complained about c.rownum - it said something like "No column named 'rownum' in table c'" which is true.
You marked that it was important to have that code for some reason; it seems to me that you are making sure that there are not multiple return values, and maybe the syntax is wrong? (not that I know the correct
syntax...)
If that is the case - you needn't worry, because the employee_number and skill_number combination are the stated primary key for table c, so uniquness is already guaranteed.
So, I ran the code without that line, input some values that would cause the error, the error message displayed properly, along with some other error messages that had me a little worried, but it seems to work fine!

Many thanks

Edmund Received on Sat Dec 01 2001 - 07:49:50 CST