Subject | Re: [IBO] Stay on newly inserted record |
---|---|
Author | Salvatore Besso |
Post date | 2005-02-28T09:50:10Z |
hello Helen,
message, just to be sure. Even using raKeepDataPos the cursor returns to the
previous record as well after the new row has been committed. Maybe there is
some other particular combination to do with other properties? I've seen also
that using caRefreshKeys (as I'm using) as CommitAction I should set
FetchWholeRows to False, but this is recommended only for a very large number of
columns and rows and since this is not the case I have left it to True.
Moreover, I'm using an explicit transaction with AutoCommit = False and
isolation = tiCommitted.
Ah, I'm using 4.5Ai.
Regards
Salvatore
> Use raKeepDataPos to ensure that the buffer cursor is onThat's the point. I have just tried another time before replying to your
> the newly inserted row after the refresh.
message, just to be sure. Even using raKeepDataPos the cursor returns to the
previous record as well after the new row has been committed. Maybe there is
some other particular combination to do with other properties? I've seen also
that using caRefreshKeys (as I'm using) as CommitAction I should set
FetchWholeRows to False, but this is recommended only for a very large number of
columns and rows and since this is not the case I have left it to True.
Moreover, I'm using an explicit transaction with AutoCommit = False and
isolation = tiCommitted.
Ah, I'm using 4.5Ai.
Regards
Salvatore