Then try setting it to caClose. It is possible that a large result set
is not causing your problem at all. It was just a thought.

--- In IBObjects@yahoogroups.com, Robert martin <rob@c...> wrote:
>
> 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.
>