0 Replies Latest reply on Mar 10, 2015 7:40 PM by Kyle {unique}

    4.1 EA2 Ignores "elsif" when capitalising keywords

    Kyle {unique}

      In the preferences under Database>SQL Formatter>Oracle Formatting (click Edit button) then under Other>Case Change and choose "Keywords Uppercase".  Even the example code does not contain the elsif keyword.

       

      Before format applied

          if lv_action = 'ALL_ACTIVE_FACILITIES' then

              lo_json     := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_FACILITY','LOV_YNT_YES');

          elsif lv_action = 'ALL_FACILITIES' then

              lo_json     := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_FACILITY','ALL');

          elsif lv_action = 'ALL_ACTIVE_EQUIPMENTS' then

              lo_json     := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_EQUIPMENT','LOV_YNT_YES');

          elsif lv_action = 'ALL_EQUIPMENTS' then

              lo_json     := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_EQUIPMENT','ALL');

          elsif lv_action = 'ALL_ACTIVE_SERVICES' then

              lo_json     := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_SERVICE','LOV_YNT_YES');

          elsif lv_action = 'ALL_SERVICES' then

              lo_json     := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_SERVICE','ALL');

          end if;

       

      After format applied

      IF lv_action = 'ALL_ACTIVE_FACILITIES' THEN

        lo_json   := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_FACILITY', 'LOV_YNT_YES');

      elsif lv_action = 'ALL_FACILITIES' THEN

        lo_json      := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_FACILITY','ALL' );

      elsif lv_action = 'ALL_ACTIVE_EQUIPMENTS' THEN

        lo_json      := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_EQUIPMENT', 'LOV_YNT_YES');

      elsif lv_action = 'ALL_EQUIPMENTS' THEN

        lo_json      := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_EQUIPMENT','ALL' );

      elsif lv_action = 'ALL_ACTIVE_SERVICES' THEN

        lo_json      := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_SERVICE', 'LOV_YNT_YES');

      elsif lv_action = 'ALL_SERVICES' THEN

        lo_json      := GET_ENTITY_FACILITIES(lv_entity_code,'LOV_AT_SERVICE','ALL');

      END IF;

       

       

      EDIT: I'm on the Mac version.

       

      Message was edited by: Kyle {unique}