gFmtOpt.case_keywords
TCaseOption
coUppercase
coLowercase
coInitCap
coNoChange
coInitCapEachWord
default: coUppercase
gFmtOpt.userdefinekeywords
lzstring
default: ''
gFmtOpt.case_identifier
default:coLowercase
gFmtOpt.case_funcname
default:coInitCap
gFmtOpt.case_datatype
default:coUppercase
gFmtOpt.DictionaryFile, used to find word when TCaseOption is set to coInitCapEachWord
lzstring
default: ''
SQL before beautify
SELECT AVG(DirectReports) AS [Average Number of Direct Reports]
froM DirReps
WHERE ((DirectReports + 2) / (20-10))>= 2
and Sal in (1000,2000,3000);
CREATE TABLE AppUser
(
UserID int NOT NULL identity(1,1) ,
FirstName varchar(100) NOT NULL ,
MiddleInitial char(3) NULL );
SQL after beautify
SELECT Avg ( directreports ) AS [average number of direct reports]
FROM dirreps
WHERE (( directreports + 2 ) / ( 20 - 10 )) >= 2
AND sal IN ( 1000, 2000, 3000 );
CREATE TABLE appuser
(
userid INT NOT NULL IDENTITY ( 1, 1 ),
firstname VARCHAR ( 100 ) NOT NULL,
middleinitial CHAR ( 3 ) NULL
);