Generate SQL code from the Online Modeller generates one comma too many for a 3-ary tie create table script. As workaround I can deletee the extra comma by hand in 2 places, which lets me create the Anchor Model database schema.
------------------------------------- [Tie Table] ------------------------------------
-- DE_has_DA_deliverydate_DA_salesdate table (3-ary)
--------------------------------------------------------------------------------------
IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'DE_has_DA_deliverydate_DA_salesdate' and type LIKE '%U%')
CREATE TABLE [dbo].[DE_has_DA_deliverydate_DA_salesdate] (
DE_ID_has int not null foreign key references [dbo].[DE_Delivery](DE_ID),
DA_ID_deliverydate int not null foreign key references [dbo].[DA_Date](DA_ID),
DA_ID_salesdate int not null foreign key references [dbo].[DA_Date](DA_ID),
Metadata_DE_has_DA_deliverydate_DA_salesdate int not null,
constraint pkDE_has_DA_deliverydate_DA_salesdate primary key (
DE_ID_has asc
),
unique (
DA_ID_deliverydate asc
),
,
unique (
DA_ID_salesdate asc
)
) ON [PRIMARY];
GO
Maybe this is already fixed in the new testversion.
Kind regards,
Tim
