Subject Re: [IBO] A little problem with RefreshAction
Author guido.klapperich@t-online.de
> What is your CommitAction set to? It's probably set to caRefresh, try
> setting it to caInvalidateCursor.

No, it is set to caInvalidateCursor. Here's the monitor-output of an Insert:

/*---
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