Thank you Helen!

I'll take a closer look at these points. If something works here I'll
let you.

Antonio

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 08:40 PM 10/03/2005 +0000, Antonio Carlos Ribeiro wrote:
>
> >Someone could tell me what's the meaning of "Executing already or not
> >in Passive mode".
> >
> >This error occurs only when I execute a TIB_Script connected to a
> >FirebirdSQL using a WAN (768k down/256k up dsl line) connection.
>
> It means that the ib_script is currently executing and is waiting
for the
> client to tell it that it has finished executing.
>
>
> >I primarily use IBO* components that are doing fine...
> >
> >My english isn't exactly good, but does it need to be in "Passive
> >mode" **or not**?
>
> Passive mode is available to TIB_Process classes (of which
TIB_Script is
> one). When set True, it allows the process to be set up so that it can
> continue to retry executing, e.g. in idle CPU time, without stalling
the
> application.
>
>
> >And what's a "Passive mode" exactly? I use PASSV in ftp connections,
> >but never saw it in databases.
>
> It's not a database attribute, but a process attribute.
>
> A TIB_Script has this property set to False. I think it needs to be
left
> in this state; otherwise (as far as I can tell) you would never know
> whether the script's execution completed or not. What you really
want is
> for the application to be in control of the statement-by-statement
> execution of the script - trap exceptions, handle time-outs, and so
on, and
> finally confirm that execution completed successfully.
>
> I haven't had the experience of executing a script across a slow
> connection, to know how to deal with disconnection, time-outs or dirty
> packets, though I suspect that this could be the source of the
problem. Or
> perhaps your application is simply attempting to re-execute the script
> while the process is still active...
>
> Don't take this as a final answer: hopefully Jason will spot it and
throw
> more light on it.
>
> Helen