Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement