At 01:55 PM 22/09/2004 +0000, you wrote:

>Is it possible not to permit database action ( like deleting,
>updating) based on SP result w/o exception message ? For example ,
>I would like to stop deleting a record if stored procedure
>called by trigger "before delete" returns me "False" , and I don't
>want to see any messages !!! .
>
>Don't be focused on deleting , because based on this I would like to
>implement that based on one field value I can stop someone to change
>another field.

An exception in a trigger is the only way to stop execution and also to the
only way to inform your client application to take the rollback action you
require. Ceate a custom exception and catch it in your application code.
If you don't want to see any messages, then don't display any!!

./heLen

>Thanx
>
>Goran
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>