Open .sql files in query tabs does not work with spaces in paths

[expired user #8700]'s profile image [expired user #8700] posted 9 years ago in Running SQL scripts Permalink
Love HeidiSQL!!! happy

Using Version 9.1.0.4867 (64 bit) and Windows 7 Home Premium with SP1, I cannot open .sql files in query tabs if the paths have spaces in the directory and/or file names.

For example, this fails:

C:\"Program Files"\HeidiSQL\heidisql.exe C:\Users\"My Username"\Desktop\SQL\Daily Active Users.sql

But this works:

C:\"Program Files"\HeidiSQL\heidisql.exe C:\DAU.sql

Obviously there is a work around.
jfalch's profile image jfalch posted 9 years ago Permalink
try

C:\"Program Files"\HeidiSQL\heidisql.exe "C:\Users\My Username\Desktop\SQL\Daily Active Users.sql"
ansgar's profile image ansgar posted 9 years ago Permalink
Exactly. Paths with spaces need to be quoted in the whole.
[expired user #8700]'s profile image [expired user #8700] posted 9 years ago Permalink
Thanks.

Please login to leave a reply, or register at first.