Upper case keywords

[jboschee]

Is there a way to force keywords to a specific case. Specifically, I am using SQL and matching braces do not work well unless the case matches (e.g. BEGIN END)

[mary.vivit]

Good day, luzzel. I've had consistent results by doing the following:
- Ensure the commands in the SQL block of your wordfile.txt are in uppercase.
- Remove any Nocase in the SQL language definition block.
- In the Syntax Highlighting tab, select the SQL language and enable Auto Correct Keywords.

There might be another way, but I've not found it.

[mspeedie]

I tried that but it does not seem to be working since I upgraded from version 10 to 12.

[Mofi]

Auto Correct Keywords works also in v12. But Auto Correct Keywords only correct the keywords while entering it. Existing wrong written keywords are not corrected.

[perl_geek]

My problem with PL/SQL is how to get words changed automatically to upper-case when they don't begin with a space.

I have inserted the word FIRST into the /C1 STYLE_KEYWORD section under PL/SQL in my WORDFILE.txt file.

If i type in p_evq_models first (a space before the word 'first') this gets converted to p_evq_models FIRST.

However, if i type in p_evq_models.first the 'first' stays as it is. The dot. before the word seems to stop the automatic upper-case working. Is there any way around this?

Thanks

[Mofi]

You can add character '.' to /Delimiters =

But you must know that now a string like p_evq_models.first is interpreted as 3 words as indicated by the 3 colors.

You should use my macro TestForInvalid to verify, if there are any invalid keyword definitions in the wordfile after adding '.' to the delimiters.

[perl_geek]

Yes I thought about that Mofi and tried it before I posted but it still leaves '.first' in lower-case

[Mofi]

You are right. Please uncheck option Do not auto-complete structure members (items following "." or "->") at Configuration - Editor - Auto-complete and then UltraEdit will not treat everything after a '.' or '>' as structure or class element which should not be automatically corrected.