Query.sql.Clear;
Query.sql.Add('SELECT * FROM Table1 WHERE ID = :ID');
Query.ParamByName('ID').Value := 5;
Query.Active := True;
Query.RecordCount = 0; // It is wrong. This statement should have returned 1; there is one record with id = 5