Update statement

Delphi

• gfmtopt.Update_Columnlist_Style, type of TAlignStyle, default is stacked.
• gfmtopt.update_set_clause_inNewLine, type of boolean, default is false.
• gfmtopt.update_from_clause_inNewLine, type of boolean, default is false.

Java

• TODO

Uniform

• Main clause newline option

  Option: fmt057_update_table_in_new_line = false, type: TFmtBoolean.

  Option: fmt059_update_set_clause_in_new_line = false, type: TFmtBoolean.

  Option: fmt060_update_where_condition_in_new_line = false, type: TFmtBoolean.

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

  Option: fmt057_update_table_in_new_line = true, type: TFmtBoolean.

  Option: fmt061_update_table_indent = n, type: int.

  Option: fmt059_update_set_clause_in_new_line = true, type: TFmtBoolean.

  Option: fmt063_update_set_clause_indent = n, type: int.

  Option: fmt060_update_where_condition_in_new_line = true, type: TFmtBoolean.

  Option: fmt064_update_where_condition_indent = n, type: int.

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

• Set clause items fit into one line

  Option: fmt065_update_set_clause_list_style = fit_into_one_line, type: TFmtListStyle.

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

• Stacked set clause items

  Option: fmt065_update_set_clause_list_style = stacked, type: TFmtListStyle.

  • Comma in the end of line

    Option: fmt066_update_set_clause_list_comma_option = after_item, type: TFmtCommaOption.

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

  • Comma in the begin of line

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

  • Comma in the begin of line, align items.

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

  • Comma in the begin of line, align items. space between comma and item is 1 or n

    Option: fmt066_update_set_clause_list_comma_option = before_item_outside_list_with_n_space, type: TFmtCommaOption.

    Option: fmt067_update_set_clause_list_comma_space = n, type: int.

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