Subject Re: Server Exceptions (was Re: [firebird-support] Is using SELECT COUNT (*) in a stored procedure a bad idea? (Once Again))
Author Daniel Rail
Hi,

At January 27, 2004, 19:49, Alexandre Benson Smith wrote:


> If the server could send more detailed data about the exceptions, I could
> format the exception message on the client side... And leave the
> referential logic just on the server and decalred just on table creation time.

There has been talks on how to implement the more detailed exceptions.
The problem at the moment is how the engine and the exception handler
operates that doesn't permit more detail. Following the discussion on
the Firebird developers group, there seems to be more work involved
than one might think, all because of how the whole architecture behind
Firebird operates. But, it wont be part of Firebird 1.5, and
hopefully these changes will make their way into FB 2.0.

> Thanks for your answer and your time... I like to see how people handle
> such situations... Imagination to try diferent aproachs bring some
> interesting ideas...

Unfortunately, I don't deal with FKs, but I've been bitten by
exceptions not giving enough information to know exactly what went
wrong, other than guessing until it worked.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)