Subject Re: [ib-support] Begin...End in SQL with Firebird...
Author Paul Reeves
Jair RC wrote:
> Hi! I would like to know if he has some forecast to implement in the
> Firebid, the feature of Tablets (Blocks) of SQL (equal to the used one in
> the Oracle).

It can't be done. You have to have a single statement per TQuery object.

There are ways of faking this. You could write scripts, for instance. Or
you could write your Delphi code in such a way as to pass several
statements to the TQuery object and commit/rollback at the end. Or you
could use stored procedures. (Yes, I know, you don't want to use stored
procedures. Why not?)



Paul Reeves
Supporting users of Firebird and InterBase