> 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.

It certainly is a mess, and considering the detail given in the API
documentation I thought there should be some reference somewhere to
explain exactly what is supposed to happen.

I am roughly familiar with what IBO does (we discussed some issues
relating to this not that long ago). It seems (no disrespect
intended) that you have had to determine your current processing
on a trial and error basis. I was hoping that someone may be able
to point me to where in the source these decisions are made so that
I could work out the actual details for my C++ code.

> 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.

Ouch! Thanks for the warning.


--
Geoff Worboys
Telesis Computing