I am seeing an issue where I am putting a Windows path in a single quote string and because it ends with a backslash, Sublime Text thinks I want to escape that closing single quote:
–> ELSE ‘C:\AltiumLibraries\Footprints**’** + Replace(mp.footprint_ref,’.’,’_’) + ‘.PcbLib’
The problem is, this then screws up the syntax highlighting for the rest of the file. I have searched and it appears that the SQL standard for escaping a single quote is doing a double single quote (’’) and not backslash quote (’). From what I have read, MySQL does not follow the standard here; I am using SQL Server.
Does anyone know where in the SQL definition file I can change this and what I would change? I might just copy the original and then make a version for SQL Server. Would I change the file in the install directory or my user specific Application Data directory? Also, do I change the Prestine Packages file (I assume not) or the files just in Packages?
Thanks for any help or pointers.
H