|Subject||[IBO] Re: application using up ram|
> >Maybe I have missed something.Open fetch the first one, AutoFetchFirst is TRUE, so this should work
> >I open a cursor like this:
> Should be MyCursor.First;
> > SomeInsQuery.FIeldByNAme('SomeValue') := MyCursor.FieldByName
> > SomeInsQuery.ExecSQL;
> Executable SQL should be
> insert into aTable (aColumn) values (:SomeValue);
> Then, before executing:
> >(* MyCursor.Close; *) No.
> > Commit;
> >Or am I using Cursors the wrong way ?
> >My customer types a number on the screen, and when he presses
> >find the according record with a cursor, like:because
> >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
> >the appl. is using up all RAM as time goes......I acutally for the fun of it just switched all TIB_Cursors to
> Well, the reason isn't obvious yet.
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
Should this be treaded anyway special ?