Stephen Boyd wrote:

>The property is called CommitAction and if you have it set to
>caFetchAll all rows for all open queries will be fetched on commit.
>Change CommitAction to caClose or caInvalidateCursor and that won't
>happen.
>
>
>
>
>

I think that caInvalidateCursor is the default, however I tried setting
it and still no better.