Subject | Re: [IBO] TIBOQuey and TIB_Cursor |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-05-24T09:02:41Z |
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
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
> At 08:38 AM 24/05/2004 +0000, you wrote:then they
> >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,
> will simply be committed, along with any pending (posted) DMLrequests
> 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