I belive that isn't the point

I imagine something like:

UPDATE table1
SET field1 = 1
WHERE field0=1;
UPDATE table2
SET field1 = 1
WHERE field0=1;
UPDATE table3
SET field1 = 1
WHERE field0=1;
DELETE FROM table4
WHERE field0=1;


It's possible?

Joao Vieira

> -----Mensagem original-----
> De: Bogdan Mugerli [mailto:mugerlibogdan@...]
> Enviada em: terça-feira, 9 de dezembro de 2003 13:11
> Para: firebird-support@yahoogroups.com
> Assunto: RE: [firebird-support] Re: Dumb Question
>
> SELECT MAX(ID) FROM TABLE1
> union
> SELECT MAX(ID) FROM TABLE2
> union
> SELECT MAX(ID) FROM TABLE3
>
> Bogdan
>
> -----Original Message-----
> > At 01:12 PM 9/12/2003 +0000, you wrote:
> > >In Oracle I'm used to using SQL to create SQL scripts.
> While I can
> > >do the same in Firebird I can't seem to figure out how to run
> > >multiple statements as a script.
> > >
> > >EXAMPLE
> > >
> > >SELECT MAX(ID) FROM TABLE1;
> > >SELECT MAX(ID) FROM TABLE2;
> > >SELECT MAX(ID) FROM TABLE3;
> >
> > This would be fine if they weren't SELECT statements. What is the
> > objective of this erm...script...?
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Buy Ink Cartridges or Refill Kits
> for your HP, Epson, Canon or Lexmark Printer at MyInks.com.
> Free s/h on orders $50 or more to the US & Canada.
> http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>