Subject [IBO] Re: application using up ram
Author Michael Vilhelmsen
--- In, Helen Borrie <helebor@t...> wrote:
> At 08:06 AM 5/03/2004 +0000, you wrote:
> > >
> > > Can you show the SQL for a couple of these dsql and cursor
> >and the
> > > code that you use with them?
> >
> >I could, but before I do, I would like to ask another thing.
> >
> >What happens if I open a cursor, and do not close it before a
commit ?
> >Will this affect this ?
> No, you don't open and close cursors. There is no buffering.
> You call First on tib_cursor to "open" it and it's "finished" when
the last
> row has been fetched.
> How many rows are you reading? Where are you putting the data?

Maybe I have missed something.

I open a cursor like this:


SomeInsQuery.FIeldByNAme('SomeValue') := MyCursor.FieldByName


Or am I using Cursors the wrong way ?

My customer types a number on the screen, and when he presses ENTER I
find the according record with a cursor, like:

Select VALUES from TABLE Where Number = :PNumber.

Thank you for your fast reply.....

I'm starting to get a problem on one of our Terminal Servers because
the appl. is using up all RAM as time goes......


> Helen