- Joined
- Mar 30, 2007
- Messages
- 1
- Reaction score
- 0
The following query
strQuery = "SELECT * FROM CIM_DataFile WHERE Drive = 'C:' AND Path = "
strQuery = strQuery & "'\\VPOP3\\' and FileName = 'VPOP3' and Extension = 'LOG'"
returns no files.
But when I take out the 'Path = ' component, it searches the disk and returns a file in the path I have coded above!
I have tried using lower and upper case but it makes no difference.
strQuery = "SELECT * FROM CIM_DataFile WHERE Drive = 'C:' AND Path = "
strQuery = strQuery & "'\\VPOP3\\' and FileName = 'VPOP3' and Extension = 'LOG'"
returns no files.
But when I take out the 'Path = ' component, it searches the disk and returns a file in the path I have coded above!
I have tried using lower and upper case but it makes no difference.