I was able to place multiple statements in a file (even select
statements) and have all the results dumped to file using your
approach below with minor modifications:

isql -u username -p password -i inputfile.sql -o
results.txt "servername:C:/Firebird/data/database.gdb"

Is there something that I am missing?

--- In firebird-support@yahoogroups.com, "chumlyii" <bgt0990@o...>
wrote:

> I tried IBEXPERT and while it does have a button to Execute and

fetch

> all it still gives me an error when it hits the second statement.

Is

> there some token/delimeter I should use between statments other
> than ';' or even '/'?
>
> select max(id) ASSAY_RULE from ASSAY_RULE;
> select max(id) ASSAY_STATUS from ASSAY_STATUS;
>
> can't format message 13:896 -- message file c:\Program
> Files\Borland\InterBase/interbase.msg not found.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 2, char 1.
> select.
>
>
> --- In firebird-support@yahoogroups.com, "Bogdan Mugerli"
> <mugerlibogdan@e...> wrote:
> > Hi
> >
> > We are using IBexpert for such things.
> >
> > Bogdan
> >
> >
> >
> > -----Original Message-----
> > From: chumlyii [mailto:bgt0990@o...]
> > Sent: Tuesday, December 09, 2003 5:07 PM
> > To: firebird-support@yahoogroups.com
> > Subject: RES: [firebird-support] Re: Dumb Question
> >
> >
> > What I was looking for was something along the lines of
> >
> > isql -user sysdba -password XXXXXXXX -input
> > d:\bgt\select_from_table.sql -output d:\bgt\results.bgt
> > d:\bgt\site_cem\nycem_fire.fdb
> >
> > This will let me run a script such as one created by
> >
> > select 'select max(id) '||RDB$RELATION_NAME||
> > 'from '||RDB$RELATION_NAME||';' from RDB$RELATIONS
> > where RDB$RELATION_NAME not like ('RDB$%')
> >
> > Which will create the script
> >
> > select max(id) APPROVAL_STATUS from APPROVAL_STATUS ;
> > select max(id) APPROVAL_STATUS_LEGEND from APPROVAL_STATUS_LEGEND;
> > select max(id) ASSAY from ASSAY ;
> > select max(id) ASSAY_FIXED_VALUE from ASSAY_FIXED_VALUE ;
> > And another 60 lines