Subject | Re: [ib-support] Parameter order in SQLDA |
---|---|
Author | Jason Wharton |
Post date | 2002-10-07T23:04:17Z |
Geoff,
It's really a mess to figure out. If you look in my statement parsing
routines you will see where I am parsing the SQL and carefully arranging the
names of the parameters according to the parameter markers. In general it is
just those parameters in the SELECT list that are post-processed. You also
have to be careful if the ORDER BY column has a numerical reference to a
column derived from a sub-select with an input parameter in it. The input
parameter is actually duplicated in the list of params.
HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
"Geoff Worboys" <geoff@...> wrote in message
news:2234525703.20021007213214@......
It's really a mess to figure out. If you look in my statement parsing
routines you will see where I am parsing the SQL and carefully arranging the
names of the parameters according to the parameter markers. In general it is
just those parameters in the SELECT list that are post-processed. You also
have to be careful if the ORDER BY column has a numerical reference to a
column derived from a sub-select with an input parameter in it. The input
parameter is actually duplicated in the list of params.
HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
"Geoff Worboys" <geoff@...> wrote in message
news:2234525703.20021007213214@......
> Hi All,
>
> Can anyone point me to documentation, or the appropriate place in
> the source, where I can discover the full details about the order
> in which input parameters are bound to the SQLDA in describe_bind?
>
> I've done much searching and can only find vagues references to
> the order being dependant on subselects. I cant find out if these
> are the only items that cause the order to change, and whether
> this happens in all instances of subselects or just those inside
> other selects.
>
> TIA
>
> --
> Geoff Worboys
> Telesis Computing
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>