Hello Lane,

 

In Database Workbench 5, I’ve an empty list as well (Firebird 3), even though the

function can be used, system table RDB$FUNCTIONS no longer includes these

system functions.

 

On your database, I’ll take it rdb$functions is empty as well.

 

I’m unsure why this should happen, is this the same when you create a new database?

 

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

 

 

 

 

 

Hello Lane,

>I've got a V2.5 DB, and using DB Workbench.

Good. ;)

>Based on a hint from the Firebird Book, I tried the following query, hoping
>to get a Session_ID:
>'select rdb$get_context('system', 'session_id') from rdb$database;'
>
>I got back a "Dynamic SQL error -804 Function unknown RDB$GET_CONTEXT"
>message. What am I doing wrong?

Well, I'm getting:
Invalid namespace name system passed to RDB$GET_CONTEXT

But at least the function works.

In Database Workbench, if you expand the "UDFs" node after establishing a
database connection, is RDB$GET_CONTEXT listed?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

***************************************************************
Actually, there's nothing in the UDFs section of my DBWorkbench... on any of my DBs. Is there something missing from my installation?

Lane C.