3 Replies Latest reply: Apr 19, 2017 9:59 AM by Hans de Vries RSS

    Date problem in Where clause

    Hans de Vries

      While trying to work out incremental load on a QVD, I ran into the following problem:

       

      First I created a QVD file with all records. Then I do a database read and store the result in a resident table. To concatenate new records into my QVD, I do a where clause on the resident table, finding records which have been added since last QVD creation time.

       

      So, I read the creation time into a variable, like this (and this works fine):

       

      Let vAanmaaktijd = num(QvdCreateTime('$(vQVDfolder)TopDesk\QVD TopDesk Versionated.qvd'));

       

       

      The contence of $(vAaanmaaktijd) = 42844,561724537

      After the database load I try to do the following:

       

      Nieuwe_records:
      Concatenate (Stamtabel) LOAD * Resident TopDesk_Wijzigingen
      where num([Datum aanmaak]) > $(vAanmaaktijd);
      Drop table
      Nieuwe_records;

       

       

      When reloading I get the following error message:

       

       

      What am I doing wrong? the field Datum aanmaak (creation date) is in format DD-MM-YYYY hh:mm:ss