Format SQL raised error

prototyper

I am issuing a RAISEERROR in a trigger behind a Navision table. This works but the message displays in the following format

The following SQL error has occurred
50001,"42000",Microsoft,[ODBC SQL Server Driver],[SQL Server]"my error message"
SQL : sql statement text

Is there a way that I can just dislay "My error Message" (50001) without all of the SQL text ?

jlandeen

One quick suggestion is that you can put whichever transaction/function/call that causes that error (or could potentially generate that error) inside a codeunit.

this way you could use the IF CODEUNIT.RUN(<Variable>) coding syntax to trap any errors. Then you can parse out the error that is returned by using the GETLASTERRORTEXT function. You should then be able to strip out all of the SQL junk that occurs before the error.

prototyper

Thanks.

Actually it is to issue an error if an object has been modified without checking it out so unfotunately not possible within Navision.