> >Maybe I have missed something.
> >
> >I open a cursor like this:
> >
> >MyCursor.ParamByName('something....
> >MyCursor.Open
>
> Should be MyCursor.First;

Open fetch the first one, AutoFetchFirst is TRUE, so this should work
anyway.

>
> >
> > SomeInsQuery.FIeldByNAme('SomeValue') := MyCursor.FieldByName
> >('Some').
> > SomeInsQuery.ExecSQL;
>
> Executable SQL should be
> insert into aTable (aColumn) values (:SomeValue);

It is.

>
> Then, before executing:
>
> SomeInsQuery.ParamByNAme('SomeValue').AsSomeType:=
> MyCursor.FieldByName('Some').AsTheSameType;
>
>
> >(* MyCursor.Close; *) No.
> > 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.
>
> That one is OK. It's your executable stuff that isn't right.
>
> >I'm starting to get a problem on one of our Terminal Servers

because

> >the appl. is using up all RAM as time goes......
>
> Well, the reason isn't obvious yet.

I acutally for the fun of it just switched all TIB_Cursors to
TIBOQuery again.
But the problem is still there.

Now I'm wondering if my TIB_DSQL is all right !
I have switched all INSERT INTO.... and UPDATE..... from TIBOQuery
to TIB_DSQL.

Should this be treaded anyway special ?

Michael

>
> Helen