I know a mate who's written a script runner and editor for isql which
lets you embed pascal script inside your isql scripts (in a similar
fashion to how you embed java in jsp files or vb in asp files - using <%
%>) and supports passing of input params and outputing stuff. It's free
and considering open source. It's not up on the net yet but said might
look at putting it up somewhere within the next few days?

If you have any interest in this let me know.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of MIDIcat Support
> Sent: Friday, 2 June 2006 12:00 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Scripting
>
> On 6/1/06, Helen Borrie <helebor@...> wrote:
> > >Where can I read about FB scripting (how to run a script
> from isql,
> > >how to pass parameters, how to control output and so on)?
> >
> > You can't pass parameters to a script and a script doesn't have
> > output. It's just a list of statements that are executed
> one by one.
> > Are you confusing "scripting" with stored procedures?
>
> No, I'm not. I'm just looking for features similar to Oracle
> SQL*Plus scripting, where:
> 1. You run a script using @my_script.sql 2. You can pass
> parameters to a script and refer to the by &1, &2 and so on
> 3. You can print something using PROMPT 4. You can ask for a
> parameter using ACCEPT 5. You can set display options using
> SET (e.g. SET FEEDBACK OFF)
>
> Regards,
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Protect your PC from spy ware with
> award winning anti spy technology. It's free.
> http://us.click.yahoo.com/97bhrC/LGxNAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources
> item on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>