Hi Wolfgang,

> I am using
>
> Try
>
> Qry.Close;
> Qry.SQL.Text := 'select rdb$get_context(''SYSTEM'',
> ''ENGINE_VERSION'') cVer from rdb$database'; // fails on engine version < 2
> Qry.ExecQuery;
> cEngineVer := Qry.FieldByName( 'cVer' ).AsString;
> Qry.Close;
> Except
> cEngineVer := '1.5.6'; // default if engine version >=2 cannot be
> verified
> End;

That works - if the difference between 1.0 and 1.5.6 doesn't matter to you - but the OP wanted a solution that didn't require opening a database connection first (and as we now know, he needs it for JDBC).


Cheers,
Paul Vinkenoog