environment variables

[eliyahu]

Enhancements in 10.0.5:
You can now use an Excel= directive in a comment section of the SQL Window to set the filename for Excel export. Supports environment variables (e.g. %date%)

But many environment variables don't work. For example, %time% don't work.

 

[Marco Kalter]

We'll check it out.

 

[ScottMattes]

I woke up this morning, not thinking of this and what popped into my mind was that using the %time% variable gives an invalid file name.

click start
type cmd
press enter
type echo %time%
press enter
type echo asdf > test_6:38:25.txt
press enter

Windows replies that it is an invalid filename.

Actually, here is what I just got:

C:\Windows\System32>echo %time%
6:23:50.02

C:\Windows\System32>echo asdf > test_6:23:50.txt
The filename, directory name, or volume label syntax is incorrect.