9 Replies Latest reply: Dec 15, 2011 3:16 AM by Dulce Sleeckx RSS

    Updating a record

      Hello everyone,

       

      I'm trying to update a qvd file with qvd file.

       

      The code that I'm using is

       

      Invoices:
      LOAD %Invoice_KEY ,
      // %Invoice_KEY ,
           InvoiceCode,
           CustomerID,
           CustomerName,
           Description,
           InvoiceDate,
           InvoiceTotal
      FROM QVD\Invoices.qvd(qvd);

      Concatenate
      LOAD %Invoice_KEY ,
           InvoiceCode,
           CustomerID,
           CustomerName,
           Description,
           InvoiceDate,
           InvoiceTotal
      FROM
      QVD\Invoices_Payments_updates.qvd
      (qvd)
      Where Exists(%Invoice_KEY);

       

       

      Demo.png


      But I get two records instead of the second one...

       

      Can someone, please, help me?

       

      Thanks in advance for the attention.

       

      Kind regards

      Piskitta