Making a field in the form as unique index that leardy has duplicate values.
Hi: I have a form which already has data. I want to make a field value Unique in the form properties. Some of the records already have duplicate values for this field. Will the system delete these records or change the field values? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Making a field in the form as unique index that leardy has duplicate values.
I believe you must go in first and change/delete the tickets. The system will fail to build the index if there are duplicate values. I would suggest going on the database level to find the duplicate tickets. You can join the table with itself to find them. For instance, to find tickets that have duplicate values for 'Field1' you can use: Select record_id from table a, table b where a.record_id != b.record_id and a.field1 = b.field1 You may have to tweak the syntax a bit, but this should give you a list of all duplicate records. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Tuesday, September 18, 2007 1:08 PM To: arslist@ARSLIST.ORG Subject: Making a field in the form as unique index that leardy has duplicate values. Hi: I have a form which already has data. I want to make a field value Unique in the form properties. Some of the records already have duplicate values for this field. Will the system delete these records or change the field values? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Making a field in the form as unique index that leardy has duplicate values.
Another SQL Server command to find dups: SELECT Field1, COUNT(*) FROM FormName GROUP BY Field1 HAVING COUNT(*) 1 Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, September 18, 2007 2:12 PM To: arslist@ARSLIST.ORG Subject: Re: Making a field in the form as unique index that leardy has duplicate values. I believe you must go in first and change/delete the tickets. The system will fail to build the index if there are duplicate values. I would suggest going on the database level to find the duplicate tickets. You can join the table with itself to find them. For instance, to find tickets that have duplicate values for 'Field1' you can use: Select record_id from table a, table b where a.record_id != b.record_id and a.field1 = b.field1 You may have to tweak the syntax a bit, but this should give you a list of all duplicate records. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravi Sent: Tuesday, September 18, 2007 1:08 PM To: arslist@ARSLIST.ORG Subject: Making a field in the form as unique index that leardy has duplicate values. Hi: I have a form which already has data. I want to make a field value Unique in the form properties. Some of the records already have duplicate values for this field. Will the system delete these records or change the field values? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Making a field in the form as unique index that leardy has duplicate values.
It will error out and not create your unique index. Remove the duplicate records or change them to be unique before creating the index. --- Ravi [EMAIL PROTECTED] wrote: Hi: I have a form which already has data. I want to make a field value Unique in the form properties. Some of the records already have duplicate values for this field. Will the system delete these records or change the field values? Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are