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