Subject | why double fetching ? |
---|---|
Author | H.Klomann |
Post date | 2002-02-13T11:04:51Z |
Hi,
since a longer time now, I´m wondering about why the IB_Monitor gives me
the information below, the a row is fetched twice.
This occurs when a IB_Query is set with FetchWholeRows=FALSE, or also
when a IB_Query is set with FetchWholeRows=TRUE and I use InvalideRows
or RefreshRows method. It seems, like every row is fetched twice. !?
Is the row really fetched twice or is there a bug in IB_Monitor or is there
an other reason I cant´t see now ?
Thanks,
Harald
/*---
EXECUTE ROW FETCH
TR_HANDLE = 15677368
STMT_HANDLE = 15676308
PARAMS = [ Version 1 SQLd 1 SQLn 1
TAB1.DB_KEY[BIND_0] = DB_KEY $8000000001000000 ]
----*/
/*---
OPEN ROW CURSOR
STMT_HANDLE = 15676308
NAME = C1461142487013534
----*/
/*---
FETCH
STMT_HANDLE = 15676308
FIELDS = [ Version 1 SQLd 4 SQLn 4
TAB1.ID = 1
TAB1.VAL = 1
TAB1.STR1 = '100'
TAB1.STR2 = '1000' ]
----*/
/*---
FETCH
STMT_HANDLE = 15676308
FIELDS = [ Version 1 SQLd 4 SQLn 4
TAB1.ID = 1
TAB1.VAL = 1
TAB1.STR1 = '100'
TAB1.STR2 = '1000' ]
ERRCODE = 100
----*/
/*---
CLOSE ROW CURSOR
STMT_HANDLE = 15676308
----*/
/*---
since a longer time now, I´m wondering about why the IB_Monitor gives me
the information below, the a row is fetched twice.
This occurs when a IB_Query is set with FetchWholeRows=FALSE, or also
when a IB_Query is set with FetchWholeRows=TRUE and I use InvalideRows
or RefreshRows method. It seems, like every row is fetched twice. !?
Is the row really fetched twice or is there a bug in IB_Monitor or is there
an other reason I cant´t see now ?
Thanks,
Harald
/*---
EXECUTE ROW FETCH
TR_HANDLE = 15677368
STMT_HANDLE = 15676308
PARAMS = [ Version 1 SQLd 1 SQLn 1
TAB1.DB_KEY[BIND_0] = DB_KEY $8000000001000000 ]
----*/
/*---
OPEN ROW CURSOR
STMT_HANDLE = 15676308
NAME = C1461142487013534
----*/
/*---
FETCH
STMT_HANDLE = 15676308
FIELDS = [ Version 1 SQLd 4 SQLn 4
TAB1.ID = 1
TAB1.VAL = 1
TAB1.STR1 = '100'
TAB1.STR2 = '1000' ]
----*/
/*---
FETCH
STMT_HANDLE = 15676308
FIELDS = [ Version 1 SQLd 4 SQLn 4
TAB1.ID = 1
TAB1.VAL = 1
TAB1.STR1 = '100'
TAB1.STR2 = '1000' ]
ERRCODE = 100
----*/
/*---
CLOSE ROW CURSOR
STMT_HANDLE = 15676308
----*/
/*---