column select

[rbrooker]

Hi,

issue with column select on 7.1.1.1339

copy this into a sql window :

Search string : WK8022
=======================================================================================================================================
                      AH_CODES.CODE                           :    1 records : select * from AH_CODES where upper(CODE) like '%WK8022%';
                         CODES.CODE                           :    1 records : select * from CODES where upper(CODE) like '%WK8022%';
                      GRP_PRIV.GP_FORM_ID                     :    3 records : select * from GRP_PRIV where upper(GP_FORM_ID) like '%WK8022%';
                    MENU_LINES.ACTION                         :    2 records : select * from MENU_LINES where upper(ACTION) like '%WK8022%';
                   PARAM_SETUP.PROGRAM                        :    1 records : select * from PARAM_SETUP where upper(PROGRAM) like '%WK8022%';
                      PROGRAMS.PATH                           :    1 records : select * from PROGRAMS where upper(PATH) like '%WK8022%';
                      PROGRAMS.PROGRAM                        :    1 records : select * from PROGRAMS where upper(PROGRAM) like '%WK8022%';
                     SECUR_TAB.TAB                            :    3 records : select * from SECUR_TAB where upper(TAB) like '%WK8022%';
            VUW_HELP_PAGE_PKGS.PKG_ID                         :    1 records : select * from VUW_HELP_PAGE_PKGS where upper(PKG_ID) like '%WK8022%';
                     VUW_PAGES.PAGE_NAME                      :   21 records : select * from VUW_PAGES where upper(PAGE_NAME) like '%WK8022%';
     WK8_TRANSN_DFLT_TEMPLATES.TRANSN_TYPE                    :    6 records : select * from WK8_TRANSN_DFLT_TEMPLATES where upper(TRANSN_TYPE) like '%WK8022%';
          WK8_TRANSN_TEMPLATES.TRANSN_TYPE                    :    6 records : select * from WK8_TRANSN_TEMPLATES where upper(TRANSN_TYPE) like '%WK8022%';
           WK8_WEB_PROGRAM_GRP.PROGRAM_NAME                   :    3 records : select * from WK8_WEB_PROGRAM_GRP where upper(PROGRAM_NAME) like '%WK8022%';
=======================================================================================================================================

use column select to copy the select statements at the end
paste them into a new sql window

the first line ( AH_CODES ) is added to the end of the second line ( CODES ) and the first line is left blank...

not by design im thinking.

thanks.

 

[Marco Kalter]

This is indeed not by design. I notice that this only happens for an empty editor. If it is not empty, or if it is made empty after it had some contents.

We'll fix it.

 

[rbrooker]

thanks.