Archives of the TeradataForum

Message Posted: Thu, 15 Jun 2006 @ 20:18:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Unfortunately not in the current version.

Since SQL Assistant uses simple string searching it first removes all special characters from its 'working' string. This includes commas, so it never sees them at all.

You will be able to do this in the next version (7.2 - due in September) as that contains a true parser.

However you may get more line breaks than you expect, since commas are used in other places, such as between parameters in built-in functions. (All commas would also be highlighted in Blue - or whatever color you specify for Keywords - since the comma will have to be defined as a keyword in order for this to work. If you want to do this you should add the comma as a new token in the 'KeywordsNLT' section of the language file. This will cause a line break and an indentation rather than just a line break. Adding it to 'KeywordsNL' would only provide a line break but might have unwanted side effects in other areas. See help file in version 7.2 for more info on language files.)

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>