Subject | TIBOQuery and selectable SP |
---|---|
Author | Ronan van Riet |
Post date | 2004-01-12T17:42:28Z |
Hello,
I am new to IBO so please bear with me!
I am having problems retrieving a dataset with my TIBOQuery.
My SQL looks like: EXECUTE PROCEDURE SP_GET_MY_PROJECTS(:I_CST_CON_ID)
SP_MY_PROJECTS can return multiple records in the dataset, when I call the
SP from IBExpert.
I am using the following code to retieve the dataset.
with IBO_QRY_MY_PROJECT do begin
Close;
if not prepared then prepare;
ParamByName('i_CST_CON_ID').Value := pWebApp.Literal['CST_CON_ID'];
IBO_QRY_MY_PROJECT.Active := true;
end;
It fails with error: invalid request handle.
What is causing this? What can I do to fix it?
Kind regards
Ronan van Riet
I am new to IBO so please bear with me!
I am having problems retrieving a dataset with my TIBOQuery.
My SQL looks like: EXECUTE PROCEDURE SP_GET_MY_PROJECTS(:I_CST_CON_ID)
SP_MY_PROJECTS can return multiple records in the dataset, when I call the
SP from IBExpert.
I am using the following code to retieve the dataset.
with IBO_QRY_MY_PROJECT do begin
Close;
if not prepared then prepare;
ParamByName('i_CST_CON_ID').Value := pWebApp.Literal['CST_CON_ID'];
IBO_QRY_MY_PROJECT.Active := true;
end;
It fails with error: invalid request handle.
What is causing this? What can I do to fix it?
Kind regards
Ronan van Riet