Subject Re: [IBO] TIBOQuey and TIB_Cursor
Author Michael Vilhelmsen
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 08:38 AM 24/05/2004 +0000, you wrote:
> >Hi
> >
> >I use several TIBOQuey and TIB_Cursor.
> >
> >Does it have any influence (Performance, Transactions etc) on the
> >system (both on client side and on server side) if I have:
> >
> >1.
> >A TIBOQuery opened when I do a COMMIT ?
> >
> >
> >2.
> >A TIB_Cursor opened when I do a COMMIT ?
>
> If those statements are inside the transaction that you commit,
then they
> will simply be committed, along with any pending (posted) DML
requests
> related to them.

So in short.
I use some Cursors to look a specific record to get some values.
Some places in my program, this Cursor doesn't get closed when a
Commit is being done. But later when I want to use it again, i ALWAYS
reopen it.

The same happens with my TIBOQuerys.
So all in all it OK ?



Regards
Michael