Hi Pavel,

Thanks for your prompt reply.

I think this is a prime example of trying before writing!.

After I sent the last message I tried my program with fdb and found that the Firebird exceptions return Database Error exceptions with the Firebird exception number included! Just what you need for mullti-language programming (or I could be getting carried away!). I think I can work with that.

Anyway, keep up the good work; it is very much appreciated.

Regards

Chris

--- In firebird-python@yahoogroups.com, Pavel Cisar <pcisar@...> wrote:
>
> Chris,
>
> in FDB, all Firebird errors are reported as Python exceptions. For more
> details about FDB you can use KInterbasDB documentation at
> http://www.firebirdsql.org/file/documentation/drivers_documentation/python/3.3.0
>
> While there are differences between these drivers, FDB is developed as
> direct replacement for KInterbasDB, so it follows the KDB interface and
> functionality as close as possible.
>
> best regards
> Pavel Cisar
> IBPhoenix
>
> Dne 24.5.2012 12:05, chrisbaldwin5339 napsal(a):
> >
> > I do have one further question, if you don't mind.
> >
> > I have to interface to a Firebird database in which user-defined
> > exceptions are used to return business rule errors back to the
> > client. I started out using pyfirebirdsql and everything seemed to be
> > ok until I deliberately tried to insert a row to a table which would
> > fail the business rules. pyfirebirdsql carried on seemingly oblivious
> > to the failure and I couldn't find any reference to trapping the
> > error (no exceptions were generated, for example). Indeed, I can't
> > find any reference to isc_status which I believe is how they are
> > reported back to the client (might be wrong about that though). So I
> > looked at alternatives and found fdb. I note that there are several
> > references to isc_status in fdb so I need to know if fdb can report
> > back these exceptions (which are firebird exceptions and probably NOT
> > python exceptions) and if so how do you use them in a Python program
> > (remember, I am a newbie at this python stuff). If not is there any
> > plan to include them and when. This is a deal breaker for me. I can
> > hold off a decision to change for a while. I want to use python but
> > will have to go back to C++ if not which I would rather not do.
> >
> > Sorry for the length of the question.
> >
> > Regards
> >
> > Chris
>