--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 01:00 AM 23/12/2004 +0000, you wrote:
>
>
> >Hi all,
> >
>
> Yup. In DSQL you can execute only one statement at a time.

Executing a

> script is something you do through a tool, either of your own

making or

> using an existing one. For example, look at the Ops Guide to see

how to

> execute a script file from the command line via isql using the -

input

> switch. Or, otherwise, code your program so it iterates through

some kind

> of list of statements that you introduce as hard code or read from

a file,

> whatever you prefer.
>
> If you're writing to the raw API, no, not if you don't write code

to do it

> by one fashion or another. If you are using a component interface

that

> provides a scripting capability then yes. There are things to

watch out

> for when executing scripts programmatically, since exceptions will

occur if

> you try to do stuff that depends on objects that your app code

hasn't

> committed.
>

So, in essence each statement must be sent separately anyway...
that's easy enough to accomplish on my end; I would have thought it
would be more efficient to send the entire script to the server in
one shot and have it execute...

>
> >I'm not sure what I'm missing here :(
>
> I can tell. :-) Maybe you should ask Santa for a copy of The

Firebird Book.

>
> ./hb

Already on order from Amazon. It will take a couple of weeks to get
it into Canada. Certainly I would expect to have less questions once
I receive this highly anticipated (and highly reviewed) book :)

Thx

Greg