Hi!

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'

Can anyone help?

Thanks!