Subject | Re: [firebird-support] RDB$GET_CONTEXT() |
---|---|
Author | Geoff Worboys |
Post date | 2014-12-13T03:16:38Z |
lcampbell lcampbell@... [firebird-support] wrote:
for FB v2.5 databases. (Might you have multiple versions of
Firebird installed and inadvertently created something from
a different version? Or be looking at databases that have
not yet been properly upgraded?)
Note also that namespaces and names are all case-sensitive
with FB context variables. So you need:
select rdb$get_context('SYSTEM', 'SESSION_ID') from rdb$database;
not that that is the reason for your reported error.
--
Geoff Worboys
Telesis Computing Pty Ltd
> Actually, there's nothing in the UDFs section of myCheck the ODS version of the databases - it should be 11.2
> DBWorkbench... on any of my DBs. Is there something missing
> from my installation?
for FB v2.5 databases. (Might you have multiple versions of
Firebird installed and inadvertently created something from
a different version? Or be looking at databases that have
not yet been properly upgraded?)
Note also that namespaces and names are all case-sensitive
with FB context variables. So you need:
select rdb$get_context('SYSTEM', 'SESSION_ID') from rdb$database;
not that that is the reason for your reported error.
--
Geoff Worboys
Telesis Computing Pty Ltd