Table tUrlRate does not have a primary key, it will not be generated...

Ola,

I’m a newbie regarding the use of the great potential of NetTiers. 

In the netTiers Generation Report i have a couple of messages like this one..

"Table tUrlRate does not have a primary key, it will not be generated..."

This table has a combined primary key of two fields and is used to deal with a many-to-many relationship between two other tables. 

why does this problem occur?And how can i solve it?

Tanks

Pedro Machado

Strange, we do support composite primary keys so i wouldn't see how that's happening, could you script out the table, and remove all the columns except for the primary keys and indexes and post it up here?

Here it is,

CREATE TABLE [dbo].[tUrlRate_Raw](

[idUrl] [numeric](18, 0) NOT NULL,

[idRate] [numeric](18, 0) NOT NULL,

CONSTRAINT [PK_tUrlRate_Raw] PRIMARY KEY CLUSTERED

(

[idUrl] ASC,

[idRate] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tUrlRate_Raw] WITH CHECK ADD CONSTRAINT [FK_tUrlRate_Raw_tRate] FOREIGN KEY([idRate])

REFERENCES [dbo].[tRate] ([rate])

GO

ALTER TABLE [dbo].[tUrlRate_Raw] CHECK CONSTRAINT [FK_tUrlRate_Raw_tRate]

GO

ALTER TABLE [dbo].[tUrlRate_Raw] WITH CHECK ADD CONSTRAINT [FK_tUrlRate_Raw_tURL_Raw] FOREIGN KEY([idUrl])

REFERENCES [dbo].[tURL_Raw] ([idURL])

GO

ALTER TABLE [dbo].[tUrlRate_Raw] CHECK CONSTRAINT [FK_tUrlRate_Raw_tURL_Raw]

this is the script of one of the tables that netTiers wont generate code for... 

 

Thanks for that, I'll try it out this evening and let you know what I find.

Pedro,

In your script i don't see where you set keys for tUrlRate_Raw table. Can you execute the following statement. It would make both idUrl and idRate a composite primary keys:

ALTER TABLE [dbo].[tUrlRate_Raw] ADD
 CONSTRAINT [PK_tUrlRate_Raw] PRIMARY KEY  NONCLUSTERED
 (
  [idUrl],
  [idRate]
 )  ON [PRIMARY]
GO

Thanks,
Michael

Pedro,

Here is complete script i used to run .nettiers against - successfully. See if it helps you.

CREATE TABLE [dbo].[tRate] (
 [idRate] [numeric](18, 0) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tURL_Raw] (
 [idUrl] [numeric](18, 0) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tUrlRate_Raw] (
 [idUrl] [numeric](18, 0) NOT NULL ,
 [idRate] [numeric](18, 0) NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[tRate] ADD
 CONSTRAINT [PK_tRate] PRIMARY KEY  CLUSTERED
 (
  [idRate]
 )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[tURL_Raw] ADD
 CONSTRAINT [PK_tURL_Raw] PRIMARY KEY  CLUSTERED
 (
  [idUrl]
 )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[tUrlRate_Raw] ADD
 CONSTRAINT [PK_tUrlRate_Raw] PRIMARY KEY  CLUSTERED
 (
  [idUrl],
  [idRate]
 )  ON [PRIMARY]
GO

ALTER TABLE [dbo].[tUrlRate_Raw] ADD
 CONSTRAINT [FK_tUrlRate_Raw_tRate] FOREIGN KEY
 (
  [idRate]
 ) REFERENCES [dbo].[tRate] (
  [idRate]
 ),
 CONSTRAINT [FK_tUrlRate_Raw_tURL_Raw] FOREIGN KEY
 (
  [idUrl]
 ) REFERENCES [dbo].[tURL_Raw] (
  [idUrl]
 )
GO

Mike and Robert

tank you very much for your help. Problem solved.

Best Regards

Pedro Machado