> 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