Hi Helen,

Please see my subsequent post about backup problems. This
erm..scrpit would give me the max record id for the 98 tables that I
need to figure out the differance between my good backup and whats
currently in the production database DB. It looks like I can use the
command line ISQL -input to read and execute the script I just have
to figure out the proper syntax for outputting it to a file.
I don't know why the gui ISQL's don't suport this (seemingly).

I would rather save the current production DB so please read that
post and tell me what you think.

Barry




--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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...?
>
>
> >It gives me an error on line 2.
> >
> >I hate to have to write a procedure for something that sould be
> >simple.
> >
> >Anyone have a solution?
>
> How about another dumb question...what's the actual problem?

(Meaning,

> what do you want to achieve?)
>
> heLen