Subject [IBO] Re: application using up ram
Author Svein Erling
Hi Michael!

I haven't read every mail between you and Helen, so if I am commenting
things that's already been settled then I'm sorry for that.

>changing every TIB_DSQL back helped.

What are the different calls you use for the TIB_DSQL? Using

TIB_DSQL1.Prepare; //done before any loop
TIB_DSQL1.ParamByName...
TIB_DSQL1.Params...
TIB_DSQL1.Execute;
TIB_DSQL1.ExecSQL;

should work OK, whereas you should avoid things like

TIB_DSQL1.Open;
TIB_DSQL1.First;
TIB_DSQL1.FieldByName...
TIB_DSQL1.Eof

If you have any other calls or assignments to your TIB_DSQLs, could
you please post an example of each to this list?

HTH,
Set