Question

What operations are performed on the data sets update in FlexiCapture?

Answer

When you run the data set update in FlexiCapture 12, operations performed with data set records are as follows:

1. If the data set record was manually edited, the edited values are not changed. They are kept in the  FlexiCapture data set.
2. If the data set record was not changed, but some record values were changed in the source database, the data set record values are replaced with database values.
3. If the data set record was not changed, and it is the same as the source database record, the values are replaced with database values. We actually do not see the difference. However, sometimes it is necessary to take into account that the record is not skipped, but rewritten.
4. If the record is deleted from the data set but exists in the source database, it will be added to the data set.
5. If the record is manually added to the data set but never existed in the source database, it will be deleted from the data set and will not be added to the source database.
6. If the record was added to the data set from the database, was never edited, but now does not exist in the source database, it will be deleted from the data set. It will not be added to the source database.
7. To erase all the edited records from the data set, it is recommended to reconnect the source database, e.g. to create a new connection string. To do it, use the Set Up... button:
   
   Or, just erase the database and update it manually. To do it, use the Clean Up button to erase and the Update button to populate the data set: 
   

You can find a detailed description and additional information about the data sets update process in the Updating data sets article.