#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    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!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2007
    Posts
    36
    Rep Power
    8
    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;

IMN logo majestic logo threadwatch logo seochat tools logo