Hi,

> Test the ROW_COUNT variable:
> IF (ROW_COUNT = 0) THEN ...

Thanks :)

> DECLARE VARIABLE msg VARCHAR(80);
> BEGIN
> msg = 'Not good';
> IF (...) THEN EXCEPTION BAD_ENTRY :msg;
>
> msg = ''Better but still not right';
> IF (...) THEN EXCEPTION BAD_ENTRY :msg;
>
> WHEN EXCEPTION BAD_ENTRY DO
> INSERT LOG (...,MessageText,...) VALUES (..., :msg,...);
> END

There are no general KEYWORDS like EXCEPTION_NAME or
EXCEPTION_MESSAGE that
holds the triggered exception and MessageText? My main SP containing
the
'WHEN EXCEPTION' clause consists of a number of other SP's where the
exceptions are triggered. So i need to change all my SP to pass the
msg back
to my main procedure.

Greetings,
Filip Moons