Subject | [IBO] Re: application using up ram |
---|---|
Author | Svein Erling |
Post date | 2004-03-05T11:22:10Z |
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.
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
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