1

Topic: Whether can check the server file presence in a folder?

I needed to make request of those records in the field of which the way to a file is registered.
But not all files are in a folder, whether it is possible to check somehow in request file presence in a folder and if True, to return necessary records?
Example, directory on a disk:

 C:\\
1.txt
3.txt
5.txt 

In a way DB:

 [u] tblPaths (id, filepath) [/u]
1; "c:\\1.txt"
2; "c:\\2.txt"
3; "c:\\3.txt"
4; "c:\\4.txt"
5; "c:\\5.txt" 

And here as though to select the records which way of a file really exists?
Such result:

 "c:\\1.txt"
"c:\\3.txt"
"c:\\5.txt" 

2

Re: Whether can check the server file presence in a folder?

xp_dirtree

3

Re: Whether can check the server file presence in a folder?

xp_fileexist