exception strange behavior

Thread View: borland.public.interbase.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Isaac Fri, 23 May 2008 14:41

#44

Author: Isaac
Date: Fri, 23 May 2008 14:41

18 lines
1598 bytes

Hello,
I am facing a strange behavior when raising an exception from inside a 
stored procedure

I have three triggers that call one stored proc after insert , after 
update and after delete

I check in the stored proc if a bal is < 0 if so then I raise an exception

I also had to do the same check in my app so I can make sure bal is 
never < 0, so the result was one time the store exception is fired 
immediately after insert a record but all other tries never raised again 
and only my application check exception is the one that always raised 
although I made the check in a save button after the user inserted as 
many item as he want

Please advice why the stored exception did not raised first !!
Thanks

Re: exception strange behavior

#56

Author: Martijn Tonies
Date: Sun, 25 May 2008 13:31

32 lines
1976 bytes

Isaac,

> I am facing a strange behavior when raising an exception from inside a
> stored procedure
>
> I have three triggers that call one stored proc after insert , after
> update and after delete
>
> I check in the stored proc if a bal is < 0 if so then I raise an exception
>
> I also had to do the same check in my app so I can make sure bal is
> never < 0, so the result was one time the store exception is fired
> immediately after insert a record but all other tries never raised again
> and only my application check exception is the one that always raised
> although I made the check in a save button after the user inserted as
> many item as he want
>
> Please advice why the stored exception did not raised first !!

Hard to tell if you don't show us anything.


-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Re: exception strange behavior

#57

Author: Isaac
Date: Sun, 25 May 2008 21:12

7 lines
1141 bytes

Martijn Tonies wrote:
> 
> Hard to tell if you don't show us anything.
Yes sorry, but I found that I was using cachedupdates and when I set it
to false the exception is fired now

Thanks for your concern

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads