Hi Ilya,
How about:
SELECT myfilename ;
FROM myfile ;
GROUP BY myfilename ;
HAVING COUNT(*) > 1 ;
INTO CURSOR sqlpass1
SELECT myfile.myfilename, myfile.myfilepath ;
FROM sqlpass1, myfile ;
WHERE myfile.myfilename = sqlpass1.myfilename ;
ORDER BY myfile.myfilename ;
INTO CURSOR sqlpass2
SELECT sqlpass2
COPY TO mytextfile.txt SDF
Hope this helps,
Gavin...
>Hello!!!
>I have a table which is field with the filenames from a directory and its subdirectories. One field in a table is a path an other one is a filename.
>I want to see if i have files with the same file names. The ones that do have same names i want sort them into a text file. How do i do that????
>Thank U.