Index already exists

BIZ TMS Data Modeler
7

Thank you very much for the project. It helped finding the issue. We fixed it here and fix will be included in next release. In case you want to fix it there and manually recompile the packages, in unit Aurelius.Sql.AnsiSQLGenerator, method TAnsiSQLGenerator.GenerateCreateDBIndex, line 166, this is how the line should be:

  Result := 'CREATE INDEX ' + IdName(DBIndex.Name) + ' ON ';

Then remove the double quotes from the index names in DBIndex attributes:

  [DBIndex('By Store ID', 'Store ID')]
  [DBIndex('By Store Name', 'Store Name')]
  [DBIndex('By Customer Code', 'Customer Code')]
  [DBIndex('By Access Code', 'Access code')]
  [DBIndex('By Store Date Modified', 'Store Date Modified')]
  [DBIndex('By SAM Date Modified', 'SAM Date Modified')]