Even more information, no in designtime :

If I make a TIBOStoredProc and set the settings, then set the active property to true, I get the following error message:

Error Creating cursor Handle

The Active property remains 'False', but the prepared property became 'True'

Now, when I set the Active property again to 'True', I get the following error:

ISC ERROR CODE: 335544327

ISC ERROR MESSAGE:
invalid request handle

STATEMENT:
TIBOInternalDataset: "DataModuleDesigner.DBData.spAppsByTimeInterval.IBOqrspAppsByTimeInterval."


Any Help?

Thanks, Tom.

----- Original Message -----
From: Tom Deprez
To: IBObjects@yahoogroups.com
Sent: Saturday, December 08, 2001 4:52 PM
Subject: Re: [IBO] TIBOStoredProc still working correctly?


I've got more information on this:

I tried to examin the problem with calling several times the same storedproc in the same conditions and the result is weird:

When I first call the storedprocedure I get this 'Error Creating Cursor Handle'. Calling it again doesn't gives me that error anymore.

What's happening?


Tom.

----- Original Message -----
From: zifnabbe
To: IBObjects@yahoogroups.com
Sent: Saturday, December 08, 2001 4:08 PM
Subject: [IBO] TIBOStoredProc still working correctly?


I use the latest version of IBObjects.

My TIBOStoredProc components are not working anymore

When a call is done to my storedproc I get the error message 'Invalid
Cursor Handle'

I've put a TIBODatabase on the datamodule
I've put a TIBOTransaction on the datamodule
I've connected the IB_Connection to the TIBODatabase
I've put a TIBOStoredProc on the datamodule
I've set the Database property
I've set the IB_Transaction to the TIBOTransaction

Now, when I want to select a StoredProcName, I get an empty list,
while there are several stored procs in my database. Is this normal?

When I set Active to True, I get the error 'Invalid Request Handler'
and Prepared becomes True. Is this normal?

Tom.


Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]