Subject | Gap between oldest and next transaction with dbexpress driver |
---|---|
Author | philippe.requile |
Post date | 2007-06-06T08:57:41Z |
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?
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?