| Subject | Re: [firebird-support] Is there way to get (with SQL) firebird version?? |
|---|---|
| Author | Milan Babuskov |
| Post date | 2008-02-19T16:25:29Z |
Tommi Prami wrote:
select coalesce(1, 0) from rdb$database
would fail in Firebird 1.0, and
execute block as begin end
would fail in Firebird 1.5 and (as already explained), you can use
RDB$GET_Context
to determine whether it's FB 2.0 or 2.1
Of course, catch the error code to be sure it didn't fail for some other
reason (bad password, network problem, etc.).
--
Milan Babuskov
http://www.flamerobin.org
> and 1.x FB/IB with some select to the RDB$ tables???Maybe you could test some features and see if queries fail. For example:
select coalesce(1, 0) from rdb$database
would fail in Firebird 1.0, and
execute block as begin end
would fail in Firebird 1.5 and (as already explained), you can use
RDB$GET_Context
to determine whether it's FB 2.0 or 2.1
Of course, catch the error code to be sure it didn't fail for some other
reason (bad password, network problem, etc.).
--
Milan Babuskov
http://www.flamerobin.org