Dmitry Kuzmenko wrote:

>>>the rest what they're missing. How hard is it to teach the driver that
>>>SELECT BLAH FROM APROC(?, ...) means it has to prepare a multi-row buffer,
>>>call EXECUTE PROCEDURE and start a fetch loop?
>
> LC> So we parse the SQL contained in the query to work out how to handle it,
> LC> rather than just running it?
>
> Whoa! Is that a real JDBC problem? Thanks God I hate Java :-)

Finish reading - I'm talking PHP across multiple database engines ;)
Having to convert aliases in the 'order by' to column numbers before
running a query is bad enough ! Oh for a standard :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services