RE: Primary Keys Duplicate Values

2002-10-08 Thread Bill Grover
[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

OT: Primary Keys Duplicate Values

2002-10-07 Thread Srimanta
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

Re: OT: Primary Keys Duplicate Values

2002-10-07 Thread Jochem van Dieten
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

RE: Primary Keys Duplicate Values

2002-10-07 Thread Robertson-Ravo, Neil (REC)
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

RE: Primary Keys Duplicate Values

2002-10-07 Thread Andy Ousterhout
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

RE: Primary Keys Duplicate Values

2002-10-07 Thread Subramanian, Samy
) 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

Re: Primary Keys Duplicate Values

2002-10-07 Thread Srimanta
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

RE: Primary Keys Duplicate Values

2002-10-07 Thread Andy Ousterhout
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

Re: Primary Keys Duplicate Values

2002-10-07 Thread Srimanta
: 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

RE: Primary Keys Duplicate Values

2002-10-07 Thread Andy Ousterhout
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