Jason,

This time I got an 'invalid request handle'. It is currently after 10pm and
I have to leave the office (the wife is going to kill me I'm sure). I
decided to try a default monitor, so here are the results (there is no data
in the table being executed against).

I'm using a TIB_Cursor, using this code:

// first this code:

FCursor->SQL->Clear();
FCursor->SQL->Add(SQLString);

// followed by (shared by other cursors that return many records):

bool PrepareDatabase(void)
{
if(FCursor)
{
FCursor->Execute();
FCursor->First();
}

return FCursor && !FCursor->Eof;
}


I used these properties for the monitor (ie, default I think):

object DBMonitor: TIB_Monitor
ItemEnd = '----*/'
MinTicks = 10
NewLineText = #13#10
OnMonitorOutputItem = DBMonitorMonitorOutputItem
Left = 56
Top = 148
end


The output of the monitor is:


TR_HANDLE = 3107708
----*/

26-11-2004 22:06:23 - ***

/*---
PREPARE STATEMENT
TR_HANDLE = 3107708
STMT_HANDLE = 3113088

EXECUTE PROCEDURE P_LP_SELECT_ONE (? /* LP_PROCESSNAME_IN */ )

FIELDS = [ Version 1 SQLd 4 SQLn 30
P_LP_SELECT_ONE.LP_PROCESSNAME = <NIL>
P_LP_SELECT_ONE.LP_LOGMASK = <NIL>
P_LP_SELECT_ONE.LP_LOGPATH = <NIL>
P_LP_SELECT_ONE.LP_DAYLIMIT = <NIL> ]
----*/

26-11-2004 22:06:23 - ***

/*---
EXECUTE2 DSQL
TR_HANDLE = 3107708
STMT_HANDLE = 3113088
PARAMS = [ Version 1 SQLd 1 SQLn 1
[LP_PROCESSNAME_IN] = 'ACMACRO' ]
FIELDS = [ Version 1 SQLd 4 SQLn 4
P_LP_SELECT_ONE.LP_PROCESSNAME = <NULL>
P_LP_SELECT_ONE.LP_LOGMASK = <NULL>
P_LP_SELECT_ONE.LP_LOGPATH = <NULL>
P_LP_SELECT_ONE.LP_DAYLIMIT = <NULL> ]
----*/

26-11-2004 22:06:23 - ***

/*---
COMMIT RETAINING
TR_HANDLE = 3107708
----*/

26-11-2004 22:06:23 - ***

/*---
EXECUTE2 DSQL
TR_HANDLE = 3107708
STMT_HANDLE = 3113088
PARAMS = [ Version 1 SQLd 1 SQLn 1
[LP_PROCESSNAME_IN] = 'ACMACRO' ]
FIELDS = [ Version 1 SQLd 4 SQLn 4
P_LP_SELECT_ONE.LP_PROCESSNAME = <NULL>
P_LP_SELECT_ONE.LP_LOGMASK = <NULL>
P_LP_SELECT_ONE.LP_LOGPATH = <NULL>
P_LP_SELECT_ONE.LP_DAYLIMIT = <NULL> ]
----*/

26-11-2004 22:06:23 - ***

/*---
COMMIT RETAINING
TR_HANDLE = 3107708
----*/

26-11-2004 22:06:23 - ***

/*---
INTERPRET BUFFER =

ERRCODE = 22
----*/

26-11-2004 22:06:23 - ***

/*---
INTERPRET BUFFER = invalid request handle

ERRCODE = -1
----*/

26-11-2004 22:06:27 - ***

/*---
COMMIT
TR_HANDLE = 3113016
----*/

26-11-2004 22:06:27 - ***

/*---
COMMIT
TR_HANDLE = 3107708
----*/

26-11-2004 22:06:27 - ***

/*---
DISCONNECT DATABASE
DB_HANDLE = 3113296
----*/

I hope this helps.


Malcolm Smith
Analyst Programmer
Comvision Pty Ltd
http://www.comvision.net.au

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Friday, 26 November 2004 19:06
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] A problem with a procedure



Tell us the component you are using and wire up a SQL trace monitor and show
the results of the exception to us.

Jason