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

ALL my TIB_DSQL are called like this:

MyDSQL.ParamByName(......
MyDSQL.ParamByName(......
MyDSQL.ParamByName(......
MyDSQL.ExecSQL;

Commit;

My DSQL only contains Insert, Update or Delete.
Nothing else.
Thats why I switched to these.

> should work OK, whereas you should avoid things like
>
> TIB_DSQL1.Open;
> TIB_DSQL1.First;
> TIB_DSQL1.FieldByName...
> TIB_DSQL1.Eof

This I never do.
Then I use either a TIBOQuery or TIB_Cursor.

Michael