Subject | Re: Error Creating cursor handle |
---|---|
Author | gifernandezmx |
Post date | 2004-02-26T16:17:13Z |
Helen,
First, thank you for your comments.
By your answer, it seems to be that spend your time in reviewing the
store procedure code, but the problem is not the code, but in the
TIBOStoreProc component.
As I said in my question, the store procedure works fine using
TIB_StoreProc Native IBObjects and then TIBStoredProc IBExpress
components.
At design time, I cannot select the storeprocedure using the
StoredProcName property in the TIBOStoreProc component, because
when the combobox is down, the list is empty. When I use the other
components, I can see all the store procedures names inside de
Interbase database.
Regards
Gerardo
First, thank you for your comments.
By your answer, it seems to be that spend your time in reviewing the
store procedure code, but the problem is not the code, but in the
TIBOStoreProc component.
As I said in my question, the store procedure works fine using
TIB_StoreProc Native IBObjects and then TIBStoredProc IBExpress
components.
At design time, I cannot select the storeprocedure using the
StoredProcName property in the TIBOStoreProc component, because
when the combobox is down, the list is empty. When I use the other
components, I can see all the store procedures names inside de
Interbase database.
Regards
Gerardo
> This is not a SELECTABLE stored procedure (although it looks as ifit ought
> to be). Your output loop needs a SUSPEND statement for each outerrow
> processed, in order for the client to get a cursor on a set ofrows.
>
> Helen