PP V3 format options

Overview of current supported format options:

• Alignments
• BlankLines
• Capitalisation
• Case Expression
• Comments
• Create table
• CTE
• Declare
• Default option
• Execute
• Expression
• Identation
• Insert
• Line number
• Line width
• Parameter
• Refactor
• Select
• Subquery
• Syntax highlighting
• Update
• Whitespace
• Output Type
• Preprocessor

Alignments

• gfmtopt.Select_keywords_alignOption, type of TAlignOption
• gfmtopt.TrueLeft, type of boolean

BlankLines

• gfmtopt.EmptyLines, type of TEmptyLinesOption
• gfmtopt.InsertBlankLineInBatchSqls, type of boolean
• gfmtopt.NoEmptyLinesBetweenMultiSetStmts, type of boolean
• gfmtopt.OnlyInsertBlankAfterGo, type of boolean

Capitalisation

• gfmtopt.case_keywords, type of TCaseOption

• gfmtopt.case_identifier, type of TCaseOption

• gfmtopt.case_quoted_identifier, type of TCaseOption

• gfmtopt.case_funcname, type of TCaseOption

• gfmtopt.case_builtinfunc, type of TCaseOption

• gfmtopt.case_datatype, type of TCaseOption

• gfmtopt.case_table_name, type of TCaseOption

• gfmtopt.case_column_name, type of TCaseOption

• gfmtopt.case_alias_name, type of TCaseOption

• gfmtopt.case_column_alias, type of TCaseOption

• gfmtopt.case_variable_name, type of TCaseOption

• gfmtopt.case_prefix_identitfer, type of TCaseOption

• gfmtopt.identifier_prefix_list, type of String

• gfmtopt.DictionaryFile, type of String

• gfmtopt.tableOrColumnCaseMappingFile, type of String

• gFmtOpt.wordSeparator, type of String

Case Expression

• gfmtopt.CaseWhenThenInSameLine, type of boolean gfmtopt.Indent_CaseFromSwitch, type of integer,default is 2 gfmtopt.Indent_Case_Then, type of integer, default is 0 gfmtopt.CaseElseExprInNewline, type of boolean gfmtopt.CaseThenExprInNewline, type of boolean gfmtopt.CaseWhenInSamelineAsCase, type of boolean

Comments

• gfmtopt.WSGap_EndLineComment, type of integer,default is 2
• gfmtopt.CMT_AlignContinuouslyEndOfLineComment, type of boolean
• gfmtopt.remove_comment, type of boolean

Create table

• gfmtopt.BEStyle_createtable_leftBEOnNewline, type of boolean
• gfmtopt.BEStyle_createtable_rightBEOnNewline, type of boolean
• gfmtopt.Createtable_ListitemInNewLine, type of boolean
• gfmtopt.Createtable_Fieldlist_Align_option, type of TAlignOption
• gFmtOpt.Createtable_Fieldlist_Style, type of TAlignStyle
• gFmtOpt.Createtable_Fieldlist_Comma_option, type of TLinefeedsCommaOption
• gfmtopt.BEStyle_createtable_leftBEIndentSize, type of integer,default is 0
• gfmtopt.BEStyle_createtable_rightBEIndentSize, type of integer,default is 0
• gFmtOpt.Createtable_fields_alignWithCreateKeyword, type of boolean

CTE

Declare

Default option

Execute

Expression

Identation

Insert

Line number

Line width

Parameter

Refactor

Select

Subquery

Syntax highlighting

Update

Whitespace

Output Type

Preprocessor

Format options in prevous version

Here is the previous version of this document: http://www.dpriver.com/ppv3/index.php