Thanks Paul,

The SQL Interactive panel is built into the application that I'm running. It provides an interface for SQL functions so that you don't need to use the command line.

I had tried the semi-colons, but I get an error message when executed...

Dynamic SQL error
error code = -104
Token unknown line 2, char 1
update

Regards.

--- In firebird-support@yahoogroups.com, Paul Vinkenoog <paul@...> wrote:
>
> allen7_24_365 wrote:
>
> > I have a multi-line command that I'm trying to run in the Firebird Interactive SQL Panel (not the command line). I can run each line independently & it works fine, but I can't seem to come up with a workable script to run it all at once (dealing with a novice here). Here's what I'm working with.....
> >
> > update catalog set mfg = 'ABC' where mfg = '123'
> > update catalog set mfg = 'DEF' where mfg = '246'
> > update catalog set mfg = 'GHI' where mfg = '789'
> > update catalog set mfg = 'CCC' where mfg = '222'
> > update catalog set mfg = 'FFF' where mfg = '999'
>
> I don't know what the "Firebird Interactive SQL Panel" is, but if it does support scripts, you probably need to end each statement with a semicolon:
>
> update catalog set mfg = 'ABC' where mfg = '123';
> update catalog set mfg = 'DEF' where mfg = '246';
> update catalog set mfg = 'GHI' where mfg = '789';
> update catalog set mfg = 'CCC' where mfg = '222';
> update catalog set mfg = 'FFF' where mfg = '999';
>
>
> HTH,
> Paul Vinkenoog
>