I even tried your sql statement and it works... one note: the -p
should read -pas...

--- In firebird-support@yahoogroups.com, "christopher_e_hall"
<chris@t...> wrote:

> 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