Hello,

and 1.x FB/IB with some select to the RDB$ tables???

-TP-


_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: 18. helmikuuta 2008 20:52
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Is there way to get (with SQL) firebird
version??



Tommi,

> Is there some simple select SQL I can verify that server is
> Firebird/Interbase and if Firebird which version of it???
>
> Some selects to the RDB$ tables maybe...

In v2.1 there is a new RDB$GET_Context call which will return the
Firebird version.

In older versions there is no definitive way to determine the version,
though there are some clues which can be used to give you some general
idea of the version (If RDB$GET_Context is defined as UDF, then version

> 2.x else version 1.x . Further if RDB$GET_Context( 'System','ODS') =

11.1 then version = 2.1 else 2.0.x)

Sean






[Non-text portions of this message have been removed]