>Hi All,
>
>I am currently writing a program that is supposed to read data from several folders. Example: there are some sub folders (data1,data2 and so on) in the DATABASE folder. May I know how to list out all the sub-folder in the DATABASE folder? Can ADIR() do the job? or some other way?

Take look at XDIR at downlads here. It is class designed specifically for tasks like this.
There is sample there of collecting folders and file names into a tmp cursor which you can use as jumpstart.

Download#25487


HTH
Sergio