topic multiple value in Application Development and Automation Discussions

multiple value

Former Member — Fri, 10 Oct 2008 08:34:55 GMT

I am creating a databse table with primary key.

my primary key should maintain a duplicate value

for example

primary key field field1

AM X

AM y

i SHOULD MAINTAIN THE VALUES IN THE BALE OF ABOVE GIVEN PATERN

Former Member — Fri, 10 Oct 2008 08:49:55 GMT

Hello

You must recreate table with another primary key which did not allow multiple values.

Also refer:

Former Member — Fri, 10 Oct 2008 08:51:26 GMT

Hi,

U can add another primary key field like serialno which has to be incremented for every insertion/ adding records in db.

Ex. 1 ab x

2 cd y

3 ab x

4 cd y.

IF useful..............

Regards.

S.Senthil kumar

Former Member — Fri, 10 Oct 2008 09:00:00 GMT

Hi Rasheed,

Choose the two fields as part of primary key.

Thanks,

Naveen Kumar.

Former Member — Fri, 10 Oct 2008 09:00:45 GMT

How can i have multiple values in the primary key

Former Member — Fri, 10 Oct 2008 09:44:31 GMT

Hi Rasheed,

if we use two fields as primary key you can have the values like this

xyz a

xyz b

but you cannot enter xyz a again in to the table as it violates primary key constraint.

Thanks,

Naveen Kumar.