--- In IBObjects@yahoogroups.com, 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

objects,

> >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:

MyCursor.ParamByName('something....
MyCursor.Open

SomeInsQuery.FIeldByNAme('SomeValue') := MyCursor.FieldByName
('Some').
SomeInsQuery.ExecSQL;

MyCursor.Close;
Commit;


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......


Michael

>
> Helen