Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Did some Googling but couldn't find this answer .. does anyone know if data sources can be referenced using Windows environment variables to define the path? Eg %HOMEPATH% = \Documents and Settings\{username}
Hi,
I think it is not possible to use environment variables directly in the LOAD statement. But you can read a path from the registry:
let vPath=GetRegistryString('HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders','Personal');
LOAD *
FROM $(vPath)\test.qvd (qvd);
- Ralf
Hi,
I think it is not possible to use environment variables directly in the LOAD statement. But you can read a path from the registry:
let vPath=GetRegistryString('HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders','Personal');
LOAD *
FROM $(vPath)\test.qvd (qvd);
- Ralf
Thanks Ralf that is as good as!