Subject Re: [IB-Architect] SQL Scripts
Author Paul Reeves
Ian Newby wrote:

> It seems to me that a lot of bugs are occuring due to the different
> way different tools deal with SQL scripts; ISQL, IBConsole, Marathon,
> Quickdesk etc all have script running facilities but these are all coded
> at the interface level. It would be much simpler to maintain if the
> script processing was performed by the server.

As far as Firebird is concerned there is no such thing as an SQL script. Even
ISQL is parsing the script into DSQL and then using the API, just like all the
other tools.

> I appreciate that this can raise a number of problems, particularly if
> multiple selects are performed, but I believe that it would reduce the
> support burden if all the tools used an in built script runner... Single
> point of failure.

So, the suggestion is that the client library incorporates a script parser and
processes the script itself?


Paul Reeves
taking InterBase further