When you open a ClientDataSet the following happens:

A transaction is started.
The query component the CDS is connected to is opened.
All records are retrieved and loaded into the CDS.
The query component is closed.
Ideally the transaction is committed.

I say "ideally" but in reality IBO does not commit the "select"
statement and then I get some errors related with deadlock because the
transactions are vey long.

Is there a way to avoid this problem in an elegant way?

Thank you