To anyone who has ideas:
Problem:

I execute the following sql statement to create a table of unique customer id's from a large table:
----------------------------------------------------------------
SELECT DISTINCT CUSTID AS ID,;
' ' AS FileName,;
.F. AS Success, ;
' ' AS ErrorMsg ;
FROM DataDBF ORDER BY ID
INTO DBF customer.DBF
-----------------------------------------------------------------
This sql statement has been used for a year and no problems have ever occurred, yesterday ended all that....I received 3 duplicate
records in a row:

ID FileName Success ErroMsg
ID2320 .F.
ID2320 .F.
ID2320 .F.

What is wrong with my sql statement ? I think maybe the other fields that I am creating at the same time are causing this. Should they be removed, I could use a SELECT DISTINCT ID....and then use an ALTER TABLE to add my other fields. ALSO I have been unable to recreate this behavior, but I can swear that it happend ( to my companies largest client, who received the same data three times and called everyone where I work to complain ! )

Any thoughts would be appreciated...
Bob Horkay