6 Replies Latest reply: Aug 6, 2014 11:18 AM by Massimo Grossi RSS

    Load only records for the five last days - easy - or is it?

    Friedrich Hofmann

      Hi,

       

      in one app I am trying to load data from a qvd, only for the five last (numeric largest) dates:

      - I have a date_value in that table

      - I make that numeric with the num() function

      - I use a WHERE() clause at the end of the LOAD statement and

      - I include all the other fields in a GROUP BY clause

      Is there anything else I need to take care of? I can't spot anything wrong - still, when I test it, the script aborts and I get the message "reload failed. Recover old data?"

      Can someone help me there?

      Thanks a lot!

       

      Best regards,

       

      DataNibbler