6 Replies Latest reply on Oct 7, 2010 2:38 AM by escargot

    Copying data from a field in all records from a found set and placing it into another table

    escargot

      Title

      Copying data from a field in all records from a found set and placing it into another table

      Post

      Hi folks,

      Hopefully you'll be able to provide me with some assistance or point me in the right direction.

      Basically, we have 2 databases that are related by client ref, when a client sends his contract back, this date is added to Database A. We would like to run a script from database B that searches Database B for all records where this date field is empty. The script will then link back Database A (where the date will exist) and put the date into the relevant field on Database B.

      Where we're stumbling is that there are circa 30000 records in database B where there is no date, I think we need to use some kind of loop so that it moves from record to record and adds the date for all records as it goes along.

      Any ideas?


      TIA.