Hi - I'm using IBO as a replacement to BDE in my delphi application.

In converting my code I've come to a problem where I need to understand FB transactions better.

In my code I need to update the metadata and data of an already running database on costumer sites.

What I would like to happen, is that the entire update and is contained within one single transaction.

As an example (From Helen Borries book):

ALTER TABLE PERSONNEL
ADD TEMP_COL VARCHAR(18);
COMMIT;

UPDATE PERSONNEL
SET TEMP_COL = CAST(TEL_NUMBER AS VARCHAR(18))
WHERE TEL_NUMBER IS NOT NULL;
COMMIT;

...

There are 2 commits, and it seems to be necessary? No way of using nested transactions here?

My problem isn't exactly with the above code, but something similar that involves altering a table, adding some data to the table, and then again altering tables, adding constraints etc in the end.

I hoped it would be possible to encapsulate it all in one transaction, so that if something goes wrong, I'll be able to do a ROLLBACK, and things will be as they were before.

What the best way to handle this kind of thing?
Thanks
Jacob