Thanks Helen - that's it - it works now!
John

> -------Original Message-------
> From: Helen Borrie <helebor@...>
> Subject: Re: [firebird-support] Re: Major stumbling block: Lack of multiple-row insert capability
> Sent: 24 Jan '07 17:29
>
> 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
>