Thanks Larry!
I forgot to trap the last line processed was the errtrap function... It should be pass in as a parameter...
--->>>
>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, MVP Visual FoxPro
LMiller3@bellatlantic.net
To maximize our learning it is essential to ask: "How can we get the most from every mistake we make?" -- Michael Gelb and Tony Buzan