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