Subject | Re: [IBO] A little problem with RefreshAction |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2003-05-11T22:58:01Z |
> What is your CommitAction set to? It's probably set to caRefresh, tryNo, it is set to caInvalidateCursor. Here's the monitor-output of an Insert:
> setting it to caInvalidateCursor.
/*---
PREPARE STATEMENT
TR_HANDLE = 25466108
STMT_HANDLE = 25469932
SELECT GEN_ID ( GEN_AOID, 1 )
FROM RDB$DATABASE
PLAN (RDB$DATABASE NATURAL)
FIELDS = [ Version 1 SQLd 1 SQLn 1
GEN_ID = 0 ]
SECONDS = 0,010
----*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 25466108
STMT_HANDLE = 25469932
PARAMS = [ ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
GEN_ID = 6 ]
SELECT COUNT: 1
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 25466108
STMT_HANDLE = 25469932
INSERT INTO ACCOUNTS
( AOID
, AONAME)
VALUES
( ? /* ACCOUNTS.AOID */
, ? /* ACCOUNTS.AONAME */ )
FIELDS = [ Version 1 SQLd 0 SQLn 30 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 25466108
STMT_HANDLE = 25469932
PARAMS = [ Version 1 SQLd 2 SQLn 2
ACCOUNTS.AOID = 6
ACCOUNTS.AONAME = 'dfgfdgreetfd' ]
INSERT COUNT: 1
----*/
/*---
COMMIT RETAINING
TR_HANDLE = 25466108
SECONDS = 0,010
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 25466108
STMT_HANDLE = 25469848
select AOID,AONAME from ACCOUNTS
WHERE AOID=? /* BIND_0 */
PLAN (ACCOUNTS INDEX (RDB$PRIMARY1))
FIELDS = [ Version 1 SQLd 2 SQLn 2
ACCOUNTS.AOID = 6
ACCOUNTS.AONAME = 'dfgfdgreetfd' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 25466436
STMT_HANDLE = 25466508
PARAMS = [ Version 1 SQLd 1 SQLn 1
[LASTID] = 91321 ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 25466108
STMT_HANDLE = 25467184
PARAMS = [ ]
----*/
Guido