Subject Gap between oldest and next transaction with dbexpress driver
Author philippe.requile
Firebird: v2.0 superserver
Program: Delphi7 with dbexpress driver

I use a TSQLCOnnection and TSQLdataset-TDatasetProvider-
TClientdataset.
I have an edit function:
if not cds.Active then cds.open;
cds.fieldbyname('V1').AsDateTime := now;
cds.Post;
cds.ApplyUpdates;

Each time I run this function, next transaction increments.
But the oldest transaction doesn't increment:
- when I close the cds
- when I close SQLConnection
- when I close the delphi program
- when I shutdown the database
- when I manually sweep the database

The oldest transaction increments only if I close SQLConnection and
then rerun the edit function.

This problem doesn't occur with a BDE application.

Who can help?