0 Replies Latest reply: Sep 19, 2011 3:55 AM by Jochen Andries RSS

    please help with incremental load

    Jochen Andries

      Hello, after some searches on the forum I did found some scripts that made it possible to do an incremental load, but I always get stuck on one way or the other

       

      Background info :

      QV Version 10 SR3

      Database = MS SQL

       

      Code :

      LOAD
          Email,
          FirstName,
          ModifyDate,
          ModifyKind,
          Name,
          PersonelId,
          PersonelPicture,
          Picture,
          SearchName;
      SQL SELECT * FROM Dehaan.dbo.Personel;

       

      I need to INSERT and UPDATE records, which I should be able to do because I have the field 'ModifyDate' and 'ModifyKind' in all of my SQL-tables. The field 'PersonelId' is the unique key in this table.

       

      Fieldinfo :

      'ModifyDate' is structured like : YYYY-MM-DD hh:mm:ss.milisec

      'ModifyKind' is : Insert, Modify, Delete (it stays I until changed)

       

      Question :

      Could somone please give me the script to do an incremental load ?  I'll make the 84 others :-)

       

      Jochen

      PS : Yes I know the STORE command isn't in the provided code