>Name = IIF ( m.Name = "PROCEDURE ", SUBSTR ( m.Name, 11 ), m.Name )
>Line = "Line Number: " + STR(LINENO())
>INSERT INTO ERRORS VALUES ( DATE(), TIME(), m.Name, ERRNUM, Msg, m.Code, m.Line)
*snip*
This will fill the table with the line number of the function Errtrap, not the line number where the error occurred. You would need to pass this in as a parameter.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao