Aage;

> Are you using "hard commits" (commit), or "soft commits" (commit

retaining) ?

We do not explicitly issue commits. The BDE manages this through its
"Shared Autocommit" support. We have examined the code and do not
find active transactions being held open for an excessive or
unexpected length of time. Here are our connection settings:

OPEN MODE=READ/WRITE
SCHEMA CACHE SIZE=16
SQLPASSTHRU MODE=SHARED AUTOCOMMIT
SCHEMA CACHE TIME=-1
MAX ROWS=-1
BATCH COUNT=100
ENABLE SCHEMA CACHE=TRUE
ENABLE BCD=TRUE
BLOBS TO CACHE=1024
BLOB SIZE=32
Keep Connection = True
Transaction Isolation Level is "Read Committed".

Thanks much.

Regards,

Hugh J Borst