uppercase

[deniskeen]

Hi!

Say we've got in a SQL window:

create view v_Uu as select * from dual;

So the "Save as .." dialog converts the view's name to uppercase (V_UU).

It would by much better to preserve the case

Denis

 

[Marco Kalter]

We'll fix this.

 

[William Robertson]

I notice that although "Keyword case" can be set in the editor preferences, you can't set "non-keyword case" (perhaps the reverse by default).

For example I have keyword case set to "Upper" and I have mapped "Edit / Selection / Apply Syntax Case" to Shift-F3 in key config. Now if I highlight a line of lowercase code and press Shift-F3, it changes to (more or less) what I want: however if I do the same to a line of uppercase code, nothing happens. I guess this makes sense given the way it's defined but it would be nice if you could apply the case you wanted.

While I'm at it, what's with SWITCH, LABEL and NAME? These insist on being keywords for some reason, which is sometimes frustrating if you work in a telecomms datawarehouse that uses labels a lot. Again, you can add custom keywords (such as NULLIF, OVER and, er, NVL) but there is no "these are not keywords" list.

Also IMHO using mixed case in a view name is misleading, because (unlike classes in Java for example) the case is not preserved with the definition. So you may think you are creating MyNewView, but what everyone else will actually have to live with is MYNEWVIEW.

 

[William Robertson]

> but there is no "these are not keywords" list
Just realised you can edit the keyword files (sql.kwf, plsql.kwf) so that particular problem is solved