Report duplicates in unique fields

In 4D v15 R3, the way to detect duplicates in fields declared as unique has been enhanced so that users have a mean to know which are the offending fields.

What’s new? All the offending fields are now displayed in an error message or in the log.

Duplicates can be reported through 2 different ways:

  • when 4D needs to create indexes on a database with offending fields.
  • during an MSC Verify scan.

Index creation

In this case, an error is displayed with the list of offending fields.

MSC dialog

MSC Verify scan

The log file contains the list of offending fields as shown below.

MSC result

For more details, please take a look at the 4D v15 R3 Upgrade manual.

Caroline Briaud
• 4D Product Team Leader •Caroline joined 4D SAS in July, 2013 as an Engineering Manager responsible for new features definition. Caroline helped the Engineering team to put in place the R-release concept, with the new development process definition and its application within 4D’s engineering teams.Caroline is now leading the 4D Product team, mainly made up of Product Owners which are representing the customers within Engineering.Caroline started her career as a software developer in the mobile phone industry. She specialized in program management with an American company in an international context spread across US, India and China.