[mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 10:13 PM
To: CF-Talk
Subject: RE: Primary Keys Duplicate Values
I have the same issue in that I have a web system that I am
integrating with
my Order Management/Mfg system. The Order Mgmt uses Product Number as
primary key, my
Hi,
Once again its me.
I have a table with 18000 records.
There are three fields say field1, field2 and field3.
There are no primary keys at the moment.
I want to delegate field1 as the primary key in the modified table.
When I try to create field1 as the primary key, an error is generated as
Quoting Srimanta [EMAIL PROTECTED]:
I have a table with 18000 records.
There are three fields say field1, field2 and field3.
There are no primary keys at the moment.
I want to delegate field1 as the primary key in the modified table.
When I try to create field1 as the primary key, an
10:43
To: CF-Talk
Subject: OT: Primary Keys Duplicate Values
Hi,
Once again its me.
I have a table with 18000 records.
There are three fields say field1, field2 and field3.
There are no primary keys at the moment.
I want to delegate field1 as the primary key in the modified table.
When I try
and State
Abbreviations where you have a reasonable expectation that the key (zip code
or abbreviation) will never change.
Andy
-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 4:43 AM
To: CF-Talk
Subject: OT: Primary Keys Duplicate Values
Hi,
Once
)
good luck
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 10:24 AM
To: CF-Talk
Subject: RE: Primary Keys Duplicate Values
If all of your current fields have meaning, I recommend that you add a new
field that is a meaningless number
PROTECTED]
Sent: Monday, October 07, 2002 10:52 PM
Subject: RE: Primary Keys Duplicate Values
Yep, your problem is that you have dupes in the column you want to tag as
a
PK. is Field 1 the only field which is uses dupe values? are the
records
technically unique or can you safely delete them
an
incredible and preventable pain in the back side.
What does everyone else recommend?
Andy
-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 1:48 PM
To: CF-Talk
Subject: Re: Primary Keys Duplicate Values
Thanks
Field 1 represents model number
: Andy Ousterhout [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 8:34 AM
Subject: RE: Primary Keys Duplicate Values
I highly recommend that you don't make Model number your primary key. Add
a
new field, numeric, and make your primary key a meaningless number
To: CF-Talk
Subject: Re: Primary Keys Duplicate Values
Thanks.
Yes I understand.
What I could do is to combine both modelno and the name of the manufacturer
and use them in updates. That should prevent updating the wrong records
should the model number not be unique.
The problem with using
10 matches
Mail list logo