Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Row #? |
Tue, Jul 10 2018 2:36 AM | Permanent Link |
Ian Branch | Hi Guys,
Trying to create a unique index but I get the message.. "The alteration could not complete due to an error with the row 1667" How do I get to/identify the row 1667 please? Regards & TIA, Ian |
Tue, Jul 10 2018 4:00 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
> Trying to create a unique index but I get the message.. > "The alteration could not complete due to an error with the row 1667" > > How do I get to/identify the row 1667 please? Never seen anything like that so wild guessing time.You have duplicates in there so you can't have a unique index Row 1667 will be the actual physical row in the table so a query SELECT * FROM table WHERE __RowID = 1667 should get it NB: its underscore underscore rowid However, you want to identify all duplicates so something like select _Forename,_Surname,count(*) from contacts group by _Surname having count(*) > 1 will do that for you Roy |
Tue, Jul 10 2018 6:51 AM | Permanent Link |
Ian Branch | Ahhh. Excellent. Thanks Roy.
Regards, Ian |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |