Beautifier set keyword to lowercase.

[jrow]

It seems to me that I've seen this issue before, but search didn't find it.

I have the "Beautifier" option for keywords set to uppercase, but it always changes them to lowercase no matter the setting.

Is there some other setting that I needs to be set?

Thanks - JR

==================================================
PL/SQL Developer
Version 7.1.5.1397
41560 - 1 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1,039,732 kB (271,384 available)
Paging file : 2,500,336 kB (1,841,712 available)
Virtual memory : 2,097,024 kB (1,948,580 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
NoQueryHints

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\row\default.ini

Plug-Ins
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Remote command Plug-in (rexec.dll) (C:\Program Files\PLSQL Developer\PlugIns\rexec.dll)
(* is Active)

Aliases
BALTIMORE_PROD
BALT-MINICC
BCFERRIES
BNE_PROD
BNE_SIT2
...

Homes
OraDb11g_home1 (D:\oracle\product\11.1.0\db_1)

DLLs
D:\oracle\product\11.1.0\db_1\bin\oci.dll

TNS File
d:\projects\tnsnames.ora

Using
Home: OraDb11g_home1
DLL: D:\oracle\product\11.1.0\db_1\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.6.0

Character Sets
Character size: 1 byte(s)
CharSetID: 0
NCharSetID: 1
Unicode Support: False
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: US7ASCII
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Marco Kalter]

Can you provide a little example?

 

[jrow]

It didn't do this before I installed Oracle 11g. Is there a default keyword file that might have been deleted?

Here is what I typed (all typed in lower case, all words automagically were converted to uppercase)

BEGIN
FOR X IN (SELECT X FROM DUAL)
LOOP
NULL;
END LOOP;
END;

Here is what Beautifier did:

begin
for x in (select x from dual)
loop
null;
end loop;
end;

Here is the preferences file:

Version=1
RightMargin=76
Indent=2
UseTabCharacter=FALSE
TabCharacterSize=2
AlignDeclarationGroups=TRUE
AlignAssignmentGroups=TRUE
KeywordCase=1
IdentifierCase=2
UseSpecialCase=FALSE
ItemList.Format=2
ItemList.Align=TRUE
ItemList.CommaAfter=TRUE
ItemList.AtLeftMargin=FALSE
EmptyLines=1
ThenOnNewLine=TRUE
LoopOnNewLine=TRUE
DML.LeftAlignKeywords=FALSE
DML.LeftAlignItems=FALSE
DML.OnOneLineIfPossible=TRUE
DML.WhereSplitAndOr=TRUE
DML.WhereAndOrAfterExpression=FALSE
DML.WhereAndOrUnderWhere=TRUE
DML.InsertItemList.Format=2
DML.InsertItemList.Align=FALSE
DML.InsertItemList.CommaAfter=TRUE
DML.InsertItemList.AtLeftMargin=FALSE
DML.SelectItemList.Format=1
DML.SelectItemList.Align=TRUE
DML.SelectItemList.CommaAfter=TRUE
DML.SelectItemList.AtLeftMargin=FALSE
DML.UpdateItemList.Format=2
DML.UpdateItemList.Align=TRUE
DML.UpdateItemList.CommaAfter=TRUE
DML.UpdateItemList.AtLeftMargin=FALSE
ParameterDeclarationList.Format=1
ParameterDeclarationList.Align=TRUE
ParameterDeclarationList.CommaAfter=TRUE
ParameterDeclarationList.AtLeftMargin=FALSE
RecordFieldList.Format=1
RecordFieldList.Align=TRUE
RecordFieldList.CommaAfter=TRUE
RecordFieldList.AtLeftMargin=FALSE
SplitAndOr=TRUE
AndOrAfterExpression=FALSE
[SpecialCase]
ALL
AND (... and a bunch more, but special case is FALSE)

 

[jrow]

Never mind. Somehow the default.kwf was deleted. I restored it from the zip file. All is good.

Thanks - JR

 

[Marco Kalter]

Okay, thanks for letting me know.