I have one table called: tMyFiles
SELECT fileName, filePath, createdOn, fileSizeKbyte, FROM tMyFiles;
I want a procedure to read fileName, filePath, createdOn, fileSizeKbyte of each file.
Starting from root directory, it enters all file names but keeps the folder names in a two dimensional array.
Why two dimentsionl array: The first level folders (folders in the root directory) are recorded as:
After the root directory files are audited, then attention is shifted to MyFolder(1, 1) or "C:\Budget" and after recording the files in this folder, all folders in MyFolder(1, 1) is recorded as:
and so fort until all.
I do not expect all to be done via this question. Having some workable solution/ progress will be fine.