3 Replies Latest reply: May 26, 2011 4:14 AM by pagneray RSS

    Pb with max in QVD local / server

      Hi everyone,

       

      I created a QVD with data sales  by month .

      I have used an attribute YearMonth to stock the month with format (YYYYMM , example 201105).

       

      After, I want to read my QVD to make incremental loading . Therefox i search a max(month) with this script

       

          maxtimes:

          LOAD

             max(anneemois) as MAXCRTTIME

          FROM

          QVD\Data.qvd (qvd);

       

          Let MAXCRTTIME = date(Peek('MAXCRTTIME',0,'maxtimes'),'YYYYMM');

       

      In local , MAXCRTTIME contains 201105

       

      With a Server, MAXCRTTIME contains a number 40672,803 !

       

      Have you an idea to help me , please ?

       

      Thnanks for advance,

      Pierrick

        • Pb with max in QVD local / server
          Deepak Kurup

          Strange... Check the server System Date and Time Setting and compare it with your local one.

           

          Also try this out.

           

          Let MAXCRTTIME =date(date#('MAXCRTTIME',0,'YYYYMM'),'YYYYMM');

           

           

          I hope this heps you out..

           

           

          Best of Luck..!!!

           

           

          Deepak

          • Pb with max in QVD local / server
            Patrick Laredo

            hi Pierrick,

             

            Firstly are you sure you are looking in the correct place or atthe right thing?

             

            You have recovered a field from your qvd file and called this MAXCRTTIME. You then have created a variable with the same name MAXCRTTIME.

             

            You now have one field and one variable. The same name but two different elements in your qvw.

             

            If you open a list box and display the field you will see 40672,803 which looks like a timestamp displayed as a number, if displayed as a timestamp this would show 2011/05/09 19:16:19.

             

            If you create a text box and put inside it =MAXCRTTIME (this is the variable) you will see 201105.

             

            Maybe this is your problem, in which case you don't have one.

             

             

            I thought there may be an issue of different settings between the server and your workstation but can't see one.

             

            Hope this helps