Syntax highlighting issue with SQL Server Script

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
Gordon

Syntax highlighting issue with SQL Server Script

Post by Gordon »

The following words are recognised as keywords and highlighted as such:
SP_EXECUTE
declare
varchar
The following however are not highlighted, yet appear as keywords in the syntax defn file (SQL2000).
@@CONNECTIONS
@@FETCH_STATUS
@@CURSOR_ROWS
@@TRANCOUNT

Does anyone have a workaround?
Dave

Re: Syntax highlighting issue with SQL Server Script

Post by Dave »

Define @ as an operator and don't prepend the @@ to the keywords in the .syn file.
Post Reply