Thread: application readable error message
Hi, I am trying to return an application error message on certain db raised errors to the form the info came from. What is the usual way for an application to identify the source of an error? The info (error type, table, column) is sometimes in the error message sometimes not, but even when it is there trying to pars the human readable message is surely not the best approach. How do you people do it? Thanks for the help. SWK Eg. - null value in column "langid" violates not-null constraint - non- null constraint violation, column, table - ERROR: insert or update on table "instrumentheader" violates foreign key constraint "instrumentheader_fk" DETAIL: Key (langid)=(ddd) is not present in table "lang". - foreign key violation, column, table ERROR: ExecInsert: rejected due to CHECK constraint "username_valid" on "users" - check constraint violation, column, table - ERROR: invalid input syntax for integer: "sss" - datatype mismatch, column, table
On 13/12/2008 19:13, SunWuKung wrote: > I am trying to return an application error message on certain db > raised errors to the form the info came from. > What is the usual way for an application to identify the source of an I suppose it depends on your development language/environment.... I use Delphi a lot, and exceptions contain the error message. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
On Dec 14, 9:31 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 13/12/2008 19:13, SunWuKung wrote:
>
> I suppose it depends on your development language/environment.... I use
> Delphi a lot, and exceptions contain the error message.
Sure, but it would mean parsing the text of the error messages - and
they probably change among versions and languages.
What I wanted to know is if there is a way to get this information as
variable/value pairs.
Thx.
SWK