Helen,

Thank you for the prompt response.

If Active is not relevant (Does not work as described in the help
file) then how should I test that the query actually returned data
before trying to access it?

Thanks,
Clive.

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> 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
>