Subject RE: [IBO] A problem with a procedure
Author Jason Wharton
I'm not sure where this is at. Fill me in on the latest here. In my mind I
thought this was all resolved but I want to be sure.

Jason Wharton

> -----Original Message-----
> From: Malcolm Smith [mailto:m.smith@...]
> Sent: Friday, November 26, 2004 4:14 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] A problem with a procedure
>
>
>
> 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