At 12:56 PM 18-02-02 +0100, you wrote:

>Hello, everybody,
>
>and thank you, Helen !
>
>I've carefully read your document
>and think that I understood
>how to use exception handling
>stuff in PSQL. I wanted
>to go somewhat further now, and
>would like to know how to identify
>the exception from a Delphi App.

First of all, if you *handle* an exception in your stored procedure, the exception won't be returned to the client.

Second, the amount of work you have to do in a Delphi app to handle the database exceptions will vary according to the data access layer you are using. The BDE returns the InterBase error code and the message defined for that error in iberror.h (in the /include directory of your InterBase installation) into a TDBError object - see the Delphi help text. IBX provides some access to the Status Vector (array of error codes). No doubt FIBPlus does something similar...and, as you have already seen, IBO provides complete encapsulation and interpretation of the Status Vector with families of IB_ISC Error classes.

>Could someone help ?
>An example ?

This list is not a Delphi list...so any development of this topic needs to be taken to a more appropriate forum. You could go to one of the b.p.i. or b.p.d. newsgroups at forums.inprise.com to ask about IBX and BDE, respectively. Both IBO and FIBPlus have their own dedicated support lists/groups

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________