Error handling

[PolarBear]

Hi All

While I'm testing dbExpress driver for Sybase I meet the next problem. I can't receive enough information about server errors.

If I try to execute a SQL statment, wich produce some server error, driver returns error message only (without error code).
If I try to execute a stored procedure, wich produce some server error, driver doesn't return any iformation about error.

Is it a bag?

[VISOCO Support]

>> If I try to execute a SQL statment, wich produce some server error, driver returns error message only (without error code).

You can use TSQLMonitor to comprehensively trace all messages that server sends to client. They have necessary format: MessageNumber, Severity, Text.
Yes, driver error messages must have the same format. This feature will be added to the next build.

>> I try to execute a stored procedure, wich produce some server error, driver doesn't return any iformation about error.

Sybase doesn't have exception's ideology as Oracle or Interbase. If one of SQL operators in a stored procedure fails server message with error description will be sent, but overall program flow doesn't interrupt. Thus, stored procedure will be completely executed.

[PolarBear]

[VISOCO Support]

Use TSQLMonitor.