SQL format options for update statement

General SQL Parser and SQL Pretty Printer Formatter options

Available format options for update set clause:

gFmtOpt.Update_Columnlist_Style	Type: TAlignStyle	Default: asStacked
gFmtOpt.DefaultCommaOption	Type: TLinefeedsCommaOption	Default: lfAfterComma

Example format options:

Name	Value
gFmtOpt.Update_Columnlist_Style	asStacked
gFmtOpt.DefaultCommaOption	lfAfterComma

Formatted SQL:

UPDATE employees
SET    department_id = 70,
       dname = 'sales',
       location = 'ca'
WHERE  employee_id = 113;

Example format options:

Name	Value
gFmtOpt.Update_Columnlist_Style	asStacked
gFmtOpt.DefaultCommaOption	lfbeforeCommaWithSpace

Formatted SQL:

UPDATE employees
SET    department_id = 70
       , dname = 'sales'
       , location = 'ca'
WHERE  employee_id = 113;

Example format options:

Name	Value
gFmtOpt.Update_Columnlist_Style	asWrapped
gFmtOpt.DefaultCommaOption	lfAfterComma

Formatted SQL:

UPDATE employees
SET department_id = 70,dname = 'sales',location = 'ca'
WHERE employee_id = 113;