3 Replies Latest reply: Oct 24, 2013 9:55 AM by Gerrit Zanen RSS

    previous command question

      My script looks as follows:

       

      InvoiceLine:

      LOAD

            previous([Shipment No_]) as PS,

            peek([Shipment No_])     as PS2,

            [Shipment No_]

      FROM

      InvoiceLine.QVD

      (qvd)

      where (Type <> 0);

       

      In the manual I find the following lines:

      pprevious command.jpg

      The return value of PS2 (the peek statement in my script) is the value from the previous line  and therefore correct.

      The return value of PS (the previous statement in my script) is the value from the current line and therefore not correct.

       

      I tried to figure out why the result in my script of the peek command differs from the previous command, but until know I have no idea.

       

      Any explanation is welcome.

       

      Regards,

       

      Gerrit