Helen,

> trying to run multiple threads on a local connection? (this isn't

possible).

All it's done in a single thread.

> What versions of everything are you using (Interbase Server,

InterBase

> Client, IB Objects, Delphi)?

IB 6.01 (on Win98) IBO 3.6 Cc D5 Sp 1

>
> If you tried to implement the suggestion to Unprepare and Prepare

in each

> iteration of the loop, please show us the code that subsequently

failed.

I haven't the exactly code here, so I hope I remeber well:

FormCreate (open some queries used by TIB_LookupCombo)
try
EditControl:=GeneratorValue;
repeat
StartTransaction;
wOk = ShowModal;
if wOk = mrOk then begin
============================
SP.Unprepare;
...Set parameters for SP
SP.Prepare;
Sp.ExecSQL;
...Get parameters from SP
============================
try
CommitRetaining
except
RollbackRetaining
end
end
else RollbackRetaining
until (wOk = mrCancel) or (transaction succeeds)
finally
FreeAndNil(Form);
end

> When you say the application "freezes", what do you mean exactly?

It does not respond to any control. I can close the application only
from IDE (Ctrl F2).

Thanks, Dorin