Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

InterBase Server Exception

0 views
Skip to first unread message

webc...@fsd.comsats.net.pk

unread,
Mar 30, 2000, 3:00:00 AM3/30/00
to
Hi Eeryone,

I am working on Interbase Server 5.5 on NT, and I am using IBComponants.

From Interbase Server, I met an Exception 'voilation FOREIGHN KEY
"INTEG_101" on Table "COLORS". I want to handle this server exception,
but i don't know how to handle this exception, from application or from
server!


Please Help Me.

Thanks.

Shahid Iqbal (Pas)

Jeff Overcash (TeamB)

unread,
Mar 30, 2000, 3:00:00 AM3/30/00
to
Wrap your Post statement for the Insert/Edit in a Try...Execpt block and handle
the exception there.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Maybe it was infatuation or the thrill of the chase.
Maybe you were always beyond my reach and my heart was playing safe.
But was that love in your eye I saw or the reflection of mine?
Give me time, won't you give me that time!
Welcome back to the circus. (Fish)


webc...@fsd.comsats.net.pk

unread,
Mar 30, 2000, 3:00:00 AM3/30/00
to
Dear Jeff,

I am using a IBTable and data is entered directly into a DBGrid, how can i apply a
try ... finaly block?

Thanks

Shahid Iqbal (Pascal)

Andres Allkivi

unread,
Mar 30, 2000, 3:00:00 AM3/30/00
to
If youre using DBGrid directly then you cant use try... finally. Instead you
can use TIBTable.OnPostError event.

Andres

webc...@fsd.comsats.net.pk wrote in
<38E37FAB...@fsd.comsats.net.pk>:

webc...@fsd.comsats.net.pk

unread,
Mar 30, 2000, 3:00:00 AM3/30/00
to
I have already done this, but the situation is still remain, and an exception is
raised by the server, mind it InterBase server is on NT Server, and my
application is on different NT workstations, I want to handle this in Server not
from Application.

Jeff Overcash (TeamB)

unread,
Mar 30, 2000, 3:00:00 AM3/30/00
to
The only way I can think of in the situation you are in to solve this on the
server is to write a before insert or before edit trigger that resolves bad
values before the actual insert happens. Or on the client side you do
validation before posting the data.

webc...@fsd.comsats.net.pk wrote:
>
> I have already done this, but the situation is still remain, and an exception is
> raised by the server, mind it InterBase server is on NT Server, and my
> application is on different NT workstations, I want to handle this in Server not
> from Application.
>

0 new messages