This is simply a result of the "old interbase" problem with leaving cursors
open and thus I did an extra benign call to make sure it got closed up. I
probably need to get inside and detect which version I'm working with and no
longer do it since this problem has been fixed by now. I believe it was a
problem in one of the 4.x versions.

In any case, it is benign. It's just affirming there was no cursor for that
handle to close.

Jason Wharton
www.ibobjects.com

-----Original Message-----
From: constantijnw [mailto:wolfs@...]
Sent: Saturday, June 05, 2004 2:35 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Error executing sp


Hello,

Below I've included a (stripped) sp. When it is executed by a TIB_DSQL
component the monitor shows an error:

[ 5-6-2004 11:28:36 ]
CLOSE ROW CURSOR
STMT_HANDLE = 14707356
ERRCODE = 335544569

This "dsql error" seems quit harmless, but does anybody know how to
get rid of it?


ALTER PROCEDURE "USER_SESSION_START2"
(
"ACCOUNTNAME" VARCHAR(32) CHARACTER SET UNICODE_FSS,
"USERNAME" VARCHAR(32) CHARACTER SET UNICODE_FSS,
"PASSWRD" VARCHAR(32) CHARACTER SET UNICODE_FSS
)
RETURNS
(
"ACCOUNTID" INTEGER
)
AS
BEGIN
ACCOUNTID = 0;
END





___________________________________________________________________________
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 !
Yahoo! Groups Links