On Fri, 16 Dec 2011 19:28:41 +0700, Ichiro Kobayashi
<nouva.lyon@...>
wrote:

> I've tried it, Thomas.
> Such as :
>
> DROP USER FONDA
>
> But it does give a message like this :
>
> "Cannot commit transaction:
> Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements.
> record not found for user: FONDA."
>
> FYI, i need to use it at my trigger.
>
> May use something like this :
>
> **
> if (exists(select distinct rdb$user
> from rdb$user_privileges
> where rdb$user=OLD.username)) then
> EXECUTE STATEMENT 'DROP USER '|| OLD.username;
> **
> ??
>
> However, Thank You in Advance Thomas, for a very quick response !

You should be able to handle the error in your trigger when you execute
that.

eg
EXECUTE STATEMENT 'DROP USER '|| OLD.username;
WHEN ANY DO
BEGIN
-- ignore
END;

You may want to use an additional check on the specific SQLCODE, GDSCODE
or SQLSTATE instead of doing a blanket catch all like this.

Mark