Helen, what do you think for IBO, if not Row.ByName() column match is
found, try with Params[]? Will it be a easy and positive improvement,
or you can see some ill / bad behaviour or side effects on this?
(this time I've solved making my select SP return the input parameter
as a output one, as you suggested, but this would not be possible with
a simple select).
regards
Marco Menardi

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
>
> Oh yes, of course! You are hoping that it will automatically use
the same
> argument because the parameter names match? I'm sure that the binding
> works on the dataset's Row.ByName() column references, not on its
> Params[]. So it would pick up the Row.ByName('a').Value, etc.
>
> For the UpdateSQL statement, you will need to bind its input
parameter to a
> column name that exists in the output set. If there is no output
column in
> the mother query that corresponds to MyParam, then you would need to
find
> some other way to pass the current
MyQuery.ParamByName('MyParam').Value to
> the UpdateSQL procedure as a constant.
>
> Helen