Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dupes
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Dupes
Miscellaneous
Thread ID:
00568807
Message ID:
00568807
Views:
57
Hi:
I have a table and that table contains duplicate records. I want to copy all the duplicate records to a temp. file.

SELECT Phon0701.ani, Phon0701.billdate, Phon0701.duedate,;
Phon0701.totlocchrg, Phon0701.entrydate, Phon0701.entryby;
FROM phon0701;
WHERE Phon0701.vendor = '12182' and deleted() = .F.;
ORDER BY Phon0701.ani;
InTo cursor CmnthlyRpt

How can I copy dup. rec. to a temp file? I try using set order to anii, but this did not work.
Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform