jft wrote:

> I put the example code from this thread into
> the following script & ran it from iSQL in
> a database created under FB2 (ver 2.0.0.12748):
>
> RECREATE TABLE TABLE1 (
> col1 integer,
> col2 integer);
> COMMIT;
> EXECUTE BLOCK AS BEGIN
> INSERT INTO TABLE1(col1,col2) VALUES(1,2);
> INSERT INTO TABLE1(col1,col2) VALUES(3,4);
> END;

Not sure why you are trying to make this complicated all you need is

RECREATE TABLE TABLE1 (
col1 integer,
col2 integer);
COMMIT;
INSERT INTO TABLE1(col1,col2) VALUES(1,2);
INSERT INTO TABLE1(col1,col2) VALUES(3,4);
COMMIT;

Why do you think you need the EXECUTE?
The inserted values will not be available in the new table until the
COMMIT so are blocked together.

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php