General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only