Hello Paul,

I appreciate your helping me with this problem!

I have not quite "got it" yet. Here is my SQL which is in my TIBQuery ( I
have removed the parameter to simplify my problem )

SELECT o_ROW_ID, o_created, o_last_upd, o_Last_Upd_by, o_projecttype,
o_desc_text, o_Calcdate
FROM SP_GET_MY_PROJECTS

And here is my SP

CREATE PROCEDURE SP_GET_MY_PROJECTS
RETURNS (
O_ROW_ID INTEGER,
O_CREATED DATE,
O_LAST_UPD DATE,
O_PROJECTTYPE VARCHAR(30),
O_DESC_TEXT VARCHAR(10),
O_CALCDATE INTEGER)
AS
begin
FOR
SELECT prj.ROW_ID row_id, prj.created, prj.last_upd,
prj.projecttype, prj.desc_text, prj.stage, prj.calcdate
FROM E_PROJECT prj
into :o_ROW_ID, :o_created, :o_last_upd,:o_projecttype, :o_desc_text,
:o_stage, :o_Calcdate
DO
SUSPEND;
end

When I call

with IBO_QRY_MY_PROJECT do begin
if not prepared then prepare;
IBO_QRY_MY_PROJECT.Active := true;
end;

the error message is 'Invalid request handle'.

Again, what is causing this?

Ronan van Riet

_________________________________________________________________
MSN Search, for accurate results! http://search.msn.nl