Thanks for that,

I was a bit perplexed that it would throw a 335544466 exception, but
when I added an OnError method it threw a different one. I'll give
your method a try.

> Hi!
>
> I can't say anything on the best way of handling the situation.

Here's what

> I did and how I figured...
>
> When I set RaiseException to false the processing after the OnError

handler

> continues. In our case it looks like it should not continue. It

seems

> processing after tries to fulfill the deletion (or whatever

operation). So I

> did:
>
> case ERRCODE of:
>
> ...
> ...
>
> // violation of FOREIGN KEY constraint "FK_NAME" on

table "REL_NAME"

> 335544466:
> begin
> NotificationToolWin.AddEISCErrorMessage(ERRCODE,

ErrorMessage,

> 'FOREIGN KEY Violation');
> RaiseException := false;
> raise EAbort.Create('');
> end;
>
> This is not the exact error you are talking about, but it should

exhibit the

> same behaviour. Seems to do what I want it to do (this is pascal -

you

> translate).
>
> After the begin the first row is my own error processing (your

message box).

> The second line you'll recognize and the third line continues the

excption

> path in execution without making further noise.
>
> Hope this helps and please comment if I'm doing something bad

here :)

>
> /Dany
>
> <support@t...> skrev i meddelandet news:atq8de+7pk0@e...
> > Hello
> >
> > I'm just learning about IB exceptions and trying to give a more

user

> > friendly response to the user.
> >
> > I have a dialog containing a TIB_Grid and an Updatebar. When the
> > user tries to delete an entry which is protected by an FK

constraint,

> > my TIB_Query.OnError shows a messagebox and sets

RaiseException=false.

> > (This is immediately after clicking delete and before any

transaction

> > methods are called)
> >
> > However, my main exception handler (Application->OnException) then
> > catches an exception 'Record was not located'. This exception,

does

> > not pass through TIBQuery.OnError. If I use a IB_SessionProp,

this

> > does not catch the exception either.
> >
> > Can anyone tell me what I'm doing wrong, or have hints on the best
> > Exceptions handling model.
> >
> > Thanks
> >
> > David
> >
> > Using FB1, IBO4.2H, BCB5, Win2k
> >
> >
> >
> >
> >
> >
>

______________________________________________________________________
_____

> > IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> > without the need for BDE, ODBC or any other layer.
> >
>

______________________________________________________________________
_____

> > http://www.ibobjects.com - your IBO community resource for Tech

Info

> papers,
> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >
> >
> >