General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi,
I have a wierd problem and I can't figure out what's happening. I have a table with a primary key called 'table_id'. When I manually open the table or when I issue a COUNT() command, I have a record count of 702 records. If I scroll down the table, there are exactely 12 records that are duplicates (meaning they have the same primary key value). That's the first wierd thing but wait, here comes the good part: If I use a scan...endscan statement and increment a variable inside that loop to count the number of records I get... 690 records! Which is the number of records I would be getting if I didn't have any duplicates.
How can this be and why didn't FoxPro pick up the duplicates when the data was entered?
Thanks a lot in advance, Stephane.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only