Format SQL raised error

prototyper
prototyper Member Posts: 70
edited 2010-08-19 in NAV/Navision Classic Client
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 ?
Sleep on it... The best solutions come at 2am

Comments

  • jlandeen
    jlandeen Member Posts: 524
    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.
    Jeff Landeen - Sr. Consultant
    Epimatic Corp.
    http://www.epimatic.com
  • prototyper
    prototyper Member Posts: 70
    Thanks.

    Actually it is to issue an error if an object has been modified without checking it out so unfotunately not possible within Navision.
    Sleep on it... The best solutions come at 2am

Categories