Hello Norm,

I will try your proposal.
Thanks!

--- In firebird-support@yahoogroups.com, Norman Dunbar <Norman@...> wrote:
>
> Morning Hugo,
>
> On 15/11/12 23:02, hugo.larson wrote:
> > Is there any way to execute with isql query and send result to a file without any headers whatsoever?
> > Im using FB 1.5.3
>
> I'm not sure about 1.5 but this works on 2.5 with the employee database:
>
> SQL> -- Turn headings off.
> SQL> set heading;
>
> SQL> -- Direct output to a file.
> SQL> output myfile.txt;
>
> SQL> -- Run query.
> SQL> select * from department;
> SQL> commit;
>
> SQL> -- Redirect all further output to the screen.
> SQL> output;
>
> SQL> -- Put headings back on again.
> SQL> set heading;
>
> Watch out though, if the output file exists, it will be appended to, not
> overwritten.
>
> HTH
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7EL
>
> Company Number: 05132767
>