Code Assistant applying syntax case

[William Robertson]

When I type the beginning of a function name, e.g. 'nv', Code Assistant kicks in and suggests a list of matching keywords (NVARCHAR2 etc). When I select 'NVL', it places 'nvl' at the prompt, in bold but lowercase. It only switches it to uppercase (my preference setting) when I enter a space after the function name.

My preference is write function names with no space before the bracket, e.g:

NVL(x,y)
UPPER(z)

Therefore whenever I let Code Assistant complete a function name, I have to either leave a space after it then go back and remove it, or else leave it lowercase and then go back and use Apply Syntax Case.

 

[Marco Kalter]

You should probably set the "Coding Style" preference of the Code Assistant to Uppercase as well.

 

[William Robertson]

Unfortunately that sets everything it supplies to uppercase, including tables, columns etc. I want keywords in uppercase, tables/columns/variables etc in lowercase. Not an unusual standard, in my experience

 

[Marco Kalter]

Maybe we can enhance this, so that if you select a language keyword from the Code Assistant, it applies the keyword capitalization rules instead of the Code Assistant capitalization rules. This seems to make sense.

 

[michaeldias]

Is there any progress on this?

The beautifier fixes this but in my mind there should be a parameter or setting to apply a rule to every keyword in sql.kwf

This is as well as the code assistant for non keywords.

 

[Marco Kalter]

No progress yet, but it's still on the to-do list.