EmEditor (text editor) Forum Index
   EmEditor Core Bug Reports
     Unable to execute SQL file passed into SQLCMD from Tools
Register To Post

Threaded | Newest First Previous Topic | Next Topic | Bottom
Poster Thread
ArthurZ
Posted on: 1/26/2012 7:21 pm
Just can't stay away
Joined: 1/26/2012
From:
Posts: 78
Unable to execute SQL file passed into SQLCMD from Tools
I am able to successfully pass a SQL file from say ConText editor using its "Tools" facilities, not so from EmEditor.
Steps to repro:

1) Create and save a SQL file that encompasses code as

USE SandBoxDb;
GO

/* This is a test */
SELECT Top 1 *
FROM test;
GO
2) Configure a new tool to launch
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE

See the rest of the setup in this image: http://www.box.com/s/6n28qruy38ehqvxnqt85

An attempt to run produces an error:

---------------------------
EmEditor
---------------------------
The directory name is invalid.

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE
---------------------------
OK
---------------------------

Please note this directory is fine.

Hint: the spaces in the path cannot be tolerated.
Yutaka
Posted on: 1/26/2012 10:08 pm
Webmaster
Joined: 9/28/2006
From: Redmond
Posts: 2399
Re: Unable to execute SQL file passed into SQLCMD from Tools
Hello ArthurZ,

The Initial directory should be "$(Dir)", not "$(Path)".

Thanks!


----------------
Yutaka Emura
Developer of EmEditor
http://www.emeditor.com/

ArthurZ
Posted on: 1/27/2012 5:23 am
Just can't stay away
Joined: 1/26/2012
From:
Posts: 78
[SOLVED] Re: Unable to execute SQL file passed into SQLCMD from Tools
Correct! Thank you.
Problem solved.
Apologize, this is not a bug, please delete or move this post.
Threaded | Newest First Previous Topic | Next Topic | Top


Register To Post
 
English čeština Deutsch español français italiano 日本語 한국어 Русский 简体中文 繁體中文