SQL Assistant - Syntax Highlighting Not Working with dollar quoting ($$)
I'm developing a function (stored procedure) and am using the normal dollar-quoting. Something like this:
SyntaxEditor Code Snippet
pUserNameVARCHAR(50), ...) RETURNSINTEGERAS$$
DECLARE NewUserId INTEGER; -- Track how many new users were created
-- Increment UserId value
SET NextValue = NextValue + CASE WHEN pUserId IS NULL THEN 1 ELSE 0 END
WHERE IdType = 'User'
The function compiles fine. When I paste the function into SQLA, the syntax highlighting takes everything in between the $$ bookends, removes all the syntax highlighting, and makes it pink (as if it were just a string value inside single quotes). I tried to get around this by renaming the dollar bookends to $BODY$, but then SQLA complains: "Unterminated dollar-quoted string at or near $BODY$. It still compiles fine outside of SQLA.
Is there a setting in SQLA to do the syntax highlighting correctly even with the dollar-quoted strings? Or is it some ODBC driver setting? It makes it hard to develop the SPs when everything is pink and unformatted :) Thanks.