Tim,

Is there any way that you could indicate the source of an error if it
occurs in a trigger?  I spent nearly two hours pulling my hair out over
a message that was telling me a field was missing when I knew for sure
it was there and finally realized the error was coming from a trigger
and referring to a detail table and not the header table for which I
was trying to execute a simple INSERT statement.


Thanks,

--
David Cornelius
CorneliusConcepts.com

David,

<< Is there any way that you could indicate the source of an error if it
occurs in a trigger?  I spent nearly two hours pulling my hair out over a
message that was telling me a field was missing when I knew for sure it was
there and finally realized the error was coming from a trigger and referring
to a detail table and not the header table for which I was trying to execute
a simple INSERT statement. >>

Yep, no problem.

--
Tim Young
Elevate Software
www.elevatesoft.com

> << Is there any way that you could indicate the source of an error if
> it occurs in a trigger?  I spent nearly two hours pulling my hair out
> over a message that was telling me a field was missing when I knew
> for sure it was there and finally realized the error was coming from
> a trigger and referring to a detail table and not the header table
> for which I was trying to execute a simple INSERT statement. >>
>
> Yep, no problem.

Thanks--that'd be really nice!

--
David Cornelius
CorneliusConcepts.com