At 04:38 PM 24/01/2007, you 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;
>
>The output was:
>SQL> RECREATE TABLE TABLE1 (
>CON> col1 integer,
>CON> col2 integer);
>SQL> COMMIT;
>SQL> EXECUTE BLOCK AS BEGIN
>CON> INSERT INTO TABLE1(col1,col2) VALUES(1,2);
>Statement failed, SQLCODE = -104
>Dynamic SQL Error
>-SQL error code = -104
>-Unexpected end of command - line 2, column 42
>SQL> INSERT INTO TABLE1(col1,col2) VALUES(3,4);
>Records affected: 1
>SQL> END;
>Statement failed, SQLCODE = -104
>Dynamic SQL Error
>-SQL error code = -104
>-Token unknown - line 1, column 1
>-END
>SQL>
>
>Am I missing something here?

Yes. You'll need to use SET TERM to change ISQL's terminator
character for regular statements - you can do it in the script if you
want to, or interactively.

./heLen