Steve Bailey wrote:

> I am using Firebird 4.0 Beta 1.

So - off-topic in Firebird Support. But, anyway...

> The release notes describe a new system function RDB$ERROR:

> "The function RDB$ERROR() takes a PSQL error context as input and
> returns the specific context of the active
> exception. Its scope is confined to the context of the
> exception-handling block in PSQL. Outside the exception
> handling block, RDB$ERROR always returns NULL"

> To test this in iSQL I have tried: select rdb$error(gdscode) from rdb$database

> This results in:
> Statement failed, SQLSTATE = 42000
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown
> -GDSCODE

> I was expecting NULL to be returned. Have I misunderstood?
>

Yes. You read that text in the chapter entitled 'PSQL'. That's
procedural SQL, the language for writing stored procedures, triggers
and executable blocks. And it's about the exception-handling block in
PSQL - meaning you will get null if you try to access it from a part
of your PSQL code that is not an exception handling block. Logically,
that's because the current exception is visible only within the EH
block and, of course, only if an exception actually occurred that
threw execution into the EH block.

Nowhere does it suggest that you could expect anything by trying to
use the function in DSQL.

Helen



---
This email has been checked for viruses by AVG.
https://www.avg.com