Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No Duplicates
Message
From
04/05/2010 17:01:48
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01462570
Message ID:
01463112
Views:
22
>
>If your original table doesn't have an ID field (or fields combinations making a unique key), then in VFP the only way would be to rely on recno()
>
>I already posted this version in my previous replies.
>
>If you want to add this to the select, then
>
>select Name, cast(0 as I) as IDField from myTable group by Name having count(*) > 1 into cursor csrDups readwrite
>
>replace all IDField with recno() in csrDups

I tried that(the first line) but im not sure the query is liking the cast
Previous
Reply
Map
View

Click here to load this message in the networking platform