At 05:16 AM 28/04/2006, you wrote:

>According to the help file TIB_DSQL.Active returns true if Execute
>returns data.
>TIB_DSQL has no Close method, so what turns Active false again?
>
>Unprepare (self defeating)?
>Setting a new value in Params[x]?
>Something else?
>All of the above<s>?

It's not relevant with a TIB_DSQL. Since it doesn't return a dataset
there's nothing more for it to do once it has executed. Any output -
such as the return values from an executable SP - will be returned in
the XSQLVAR that was defined at the Prepare. Just read the value(s)
from the Fields[] array and do what you need to do: apply new values
to the input params for the next execution, commit or roll back the
transaction, or whatever.

Helen