>>>>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
>>>
>>>
>>>im Tryin that (the 1st line) but im not too sure the query is liking that cast
>>
>>Do you get an error?
>
>yea i did synax error nothing two big
>

>t Select fname,Cast(0 as 1) as clientid from otest;
>group by fname having count (*)>1;
>into cursor csrdups readwrite
>

:))

1 is not 1. It is supposed to be I or may be you can spell it out - Integer.

E.g.

select fName, cast(0 as Integer) as ClientID from oTest group by fName having count(*) > 1 ....