Community

I am using Textpad 4.4.1 to write Transact-SQL scripts. A lot of the scripts that I write contain character strings which I usually use as SQL statements. For readability I wrap the lines so the one string becomes multiple lines but still the same string. When this happens Textpad only syntax colors the first line of the character string. Is there any way for Textpad to recognize that the string is not complete until the final closing character string terminator?

Example:

Set @strSomeString = 'This is the first line of the string
This is the second line in the continued string
This is the third line in the continued string'

I would need the whole string block to be colored and not just the first line which currently happens.

Thank you,
Shane Fischer

Go to configure/preferences/document classes (and expand it), select the one you're using (.sql or whatever) and expand the entry, select SYNTAX and click the "open" button to get teh syntax file into textpad for editing (and then cancel the preferences window); Near the bottom of the [syntax] section there should be an entry:

StringsSpanLines = Yes

Or rather, in your case it *won't* be there, so add it. Save and exit the .syn file, and make sure you don't have any files in that class open. After that it should act the way you want ^_^