June 24th, 2013, 03:52 AM
-
Deleting rows is not working
Hi,
I have a Firebird database and I want to delete old entries.
Before I start deleting old entries I check the oldest entry:
SELECT min(in_timestamp) FROM tsyslog;
Output was 2011-05-01 ...
So, I execute following command:
DELETE FROM tsyslog WHERE in_timestamp BETWEEN '2011-05-01' AND '2012-07-01';
After finishing I check the oldest entry:
SELECT min(in_timestamp) FROM tsyslog;
Output was 2012-07-01.
So, all fine. Then I did a Backup and Restore and check the oldest entry:
SELECT min(in_timestamp) FROM tsyslog;
Output was 2011-05-01....
Did I miss something? Why there are old entries?? There should be 2012-07-01.
Can you help me please? Thank you 
greetings
Karl der Heinz!
June 25th, 2013, 12:14 AM
-
Try to do a commit command after your delete instruction:
DELETE FROM tsyslog WHERE in_timestamp BETWEEN '2011-05-01' AND '2012-07-01';
COMMIT;