>I have been following your thread and even though this may not be the speed demon your are looking for, it may help with these other questions.
>
>Check out
Query Tool.
>
>To get a list of files from a specific folder and child folders for modified date in descending order, you execute:
>
>lnCount = Query([SELECT * FROM FILE "\LifeCycle\*.*" RECUR WHERE modified >= {^2009/01/01} ORDER BY Modified DESC INTO CURSOR qtemp])
>
>
>(the Recur clause tell the driver to recurs the folder starting at \LifeCycle).
>
>As for the Users name, I am sure it could easily be added to the driver. By the way, where do you get the user name information? I have look at a few examples, but have not yet implemented any of them.
>
Update:
I added a few additional fields to hold more information about the files. Namely the person who owner and/or the author.
Chaim, you should be receiving a updated version of the File.Prg that exists in the Query\Data_Drivers folder. Overwrite the existing and rebuild the Query.Pjx. to Query.app.
Here are few more examples:
? Query([select * from file "C:\USERS\GREG\DESKTOP\DOCS\*.*" recur where ATC("greg",Owner)>0 into cursor qtemp])
BROWSE
? Query([select * from file "C:\USERS\GREG\DESKTOP\DOCS\*.*" recur where ATC("greg",author)>0 into cursor qtemp])
BROWSE
After the Class definition is a list of all 268 fields that can be associated with the files. Because FoxPro cursors are limited to the number of fields per row, I only selected few more interesting one for now. Feel free to expand the field list if you chose. I need to do a bit more refactoring and clean-up before I release to the public.
Naomi, thank again for pointing this out. I guess I had already start the implementation and got side tracked somewhere.
Greg Reichert