--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
>
> > ExecQuery;
>
> Would make more sense to call .Open, wouldn't it?
>
> > finally
> > if Open then
>
> Is Open a method? I thought that calling .Open actually
> opens it. Shouldn't that be: if Active ?
>
> > > Are you sure?
>
>
> > Close;
>
> > Not good to close the query when its open in a finally clause?
>
> Well, if the "close" fails, for any reason, any code after it will
> not be executed, like this Commit, for example.
>
> > Transaction.Commit;
> > end;
> > end;
> > finally
> > FreeAndNil(TempStream);
> > end;
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>


> Is Open a method? I thought that calling .Open actually
> opens it. Shouldn't that be: if Active ?

Hi Martijn,

Nop, TFIBQuery.Open 'Use the read only Open property to determine if
the query is open.', but u got a point on the close when it raizes an
exception in the finally clause. Thanks.

Greetings,
Filip Moons