Other than unique keys, could there be a rule violation on that, or
another, column?
When you look at the row count, before and and after the reload, are
they the same?
Ben
TOM HART wrote:
Just tried that and said no rows satisfy where clause.
Tom
----- Original Message ----
From: Ben Petersen <[EMAIL PROTECTED]>
To: RBASE-L Mailing List <[email protected]>
Sent: Saturday, August 30, 2008 9:17:57 PM
Subject: [RBASE-L] - Re: Unique value
Hi Tom,
You could:
Select colName, count(*) from tblName group by colName having count(*) > 1
Ben
TOM HART wrote:
I have a table that has a PK and everything works fine but today I
was doing some maintenance and did a reload, when it got to reloading
the suspect table I get the error that it must contain a unique
value. If I do an autochk it does not show any errors. So two
questions: 1. What happened, and 2. How do I find the culprit in 85K
rows.
Tom Hart
