Snippet Manager

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Snippet Manager

Postby delux » Tue Sep 07, 2010 9:01 pm

If I try to add a snippet titled "prn" (without quotes), I get an error message below. However, if I change the name it works fine.

SQL Prompt cannot save this snippet to the folder:

C:\\ Users\\<profile>\\AppData\\Local\\Red Gate\\SQL Prompt 4\\Snippets

Check that the folder is not read-only, or that it has not been deleted or renamed.
delux
 
Posts: 9
Joined: Thu Jan 28, 2010 7:22 pm

Postby CodantiM » Wed Sep 08, 2010 5:29 pm

PRN is a reserved file name in DOS/Windows that references your printer, so I suspect that is the problem.

I would have though having the ".sqlpromptsnippet" extension would have prevented the problem, but I guess not.

There are a number of other reserved names, for example COM1, LPT1, etc. that can't be used.
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby delux » Wed Sep 08, 2010 5:32 pm

Wow, I guess I've just never tried to name something that. I just tried to create a file prn.txt and it did not work. Good catch!

Thanks!
delux
 
Posts: 9
Joined: Thu Jan 28, 2010 7:22 pm


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests