Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicate Record Program
Message
From
13/01/2002 18:40:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Duplicate Record Program
Miscellaneous
Thread ID:
00604127
Message ID:
00604127
Views:
61
How should one execute a search in VFP for duplicate records knowing only the table name?

I do not know how to pull the field names into the following pseudo-code:

select *, count(*) as cnt from TABLE_NAME;
group by [ALL THE FIELD NAMES];
having count(*)>1
Next
Reply
Map
View

Click here to load this message in the networking platform