| Subject | Re: [IBO] Error Creating cursor handle |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-02-25T20:37:46Z |
At 06:21 PM 25/02/2004 +0000, you wrote:
Gerardo,
This is not a SELECTABLE stored procedure (although it looks as if it ought
to be). Your output loop needs a SUSPEND statement for each outer row
processed, in order for the client to get a cursor on a set of rows.
Helen
>Hi to all,[snip]
>
>My name is Gerardo. Can anybody help me?
>
>The scenario is the following:
>
>1. I have an Interbase StoreProcedure named GLOBALREPORTAMOUNTS.
>This store procedure has only output parameters.
>
>2. I'm using no Native IBObjects components. Thus I have put a
>TIBODatabase and TIBOStoredProc components in a form.
>
>3. I set the TIBODatabase properties to use the database with the
>GLOBALREPORTAMOUNTS storedprocedure.
>
>4. I set the IB_connection property in the TIBOStoredProc component.
>
>5. When i want to select the StoreProcedure name from the
>storedprocname property, I never obtain a list.
>
>6. I do the same using the Native IBObjects components and this
>works fine, also it woeks if I use IBExpress componets.
>
>7. Thus I treid to do this at runtime but an exception is
>raised: "Error Creating cursor handle".
>
>What am I doing wrong?
>
>The store procedure is defined as:
Gerardo,
This is not a SELECTABLE stored procedure (although it looks as if it ought
to be). Your output loop needs a SUSPEND statement for each outer row
processed, in order for the client to get a cursor on a set of rows.
Helen