Helen Borrie 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?

So we parse the SQL contained in the query to work out how to handle it,
rather than just running it?
I don't play with the java stuff enough to see what is wrong there, but
from the ADOdb/PHP view, I have fbird_query() and I feed it with SQL
'SELECT BLAH FROM APROC(?, ...)' or 'EXECUTE PROCEDURE', but at the
'agnostic' level, I need to decide how to process an 'execute procedure'
based on the engine that is being used. It is a case of handling the
lowest common denominator, but with the goal posts moving on other
engines as they play catch up, it's fun. So how do I know if the
particular query I am working with returns values or not - given that I
don't need to know what is in the procedure?
Perhaps Roman - we need to define the problem better?

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