> On 23/10/06, Ivan Prenosil <Ivan.Prenosil@...> wrote:
> > > I've got the IB6 pdf but is there anything better or more recent?
> > >
> > > what I'm trying to do is call a selectable SP, from C,
> passing in 1 paramenter.
> > >
> > > the sql looks like "select a, b from mysp ( ? )"
> > >
> > > I setup 2 xsqlca areas, call
> > > isc_start_transaction, #
> > > isc_dsql_allocate_statement,
> > > isc_dsql_prepare (passing output xsqlca)
> > > isc_dsql_describe_bind (passing input xsqlca)
> > > isc_dsql_execute2(passing both input & output xsqlc)
> > > at this point I get an error
> > > Invalid token
> > > SQL error code = -104
> > > - Unexpected end of command
> >
> > You should use isc_dsql_execute() with "select ...",
> > isc_dsql_execute2() is for "execute procedure ..."
> >
> > Ivan
>
> The ApiGuide says otherwise at the top of page 318. paraphase "When a
> statement has both input parameters and return values use
> isc_dsql_execute2"
>
> - hence some of my confusion.
>

return value(s) is different from result set.
Alan