"You should define a primary key for this table" - I've already got one!

BigToque · 02-14-2005, 07:03 AM

I've got a table that contains profile information of hockey players from my team.

when I use my select statement:

Code:

SELECT players.f_Name, players.l_Name, players.number, players.hand, players.height, players.weight, players.AKA,players.DOB, players.location, players.position, players.spare, players.imgURL
FROM players

It selects my data, but I get a question mark saying "You should define a primary key for this table". I've already got a primary key set.

What's going on?

Kiwi · 02-14-2005, 10:01 AM

What was your CREATE statement for the table?

02-14-2005, 07:03 AM	PM User \| #1
BigToque New Coder Join Date: Jan 2005 Posts: 38 Thanks: 0 Thanked 0 Times in 0 Posts	"You should define a primary key for this table" - I've already got one! I've got a table that contains profile information of hockey players from my team. when I use my select statement: Code: SELECT players.f_Name, players.l_Name, players.number, players.hand, players.height, players.weight, players.AKA,players.DOB, players.location, players.position, players.spare, players.imgURL FROM players It selects my data, but I get a question mark saying "You should define a primary key for this table". I've already got a primary key set. What's going on?

02-14-2005, 10:01 AM	PM User \| #2
Kiwi Regular Coder Join Date: Oct 2002 Posts: 379 Thanks: 0 Thanked 0 Times in 0 Posts	What was your CREATE statement for the table? __________________ Strategy Conscious

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread: