7 Replies Latest reply: Feb 20, 2013 11:51 AM by ahnet ceylan RSS

    show more columns in listbox

    ahnet ceylan

      Hello everyone ,

       

      I have columns called one ,two , three.....thrty three

      How can I show these columns in list box in order to select one of them and show data linked that column value

        • Re: show more columns in listbox
          ahnet ceylan

          My load script is in below,

          I want to list 1,2,3,4,...33 in a listbox

          LOAD

             `EMPLOYEE_NO` as Sicil_No,   

              BIR as 1,

              IKI as 2,

              UC as 3,

              DORT as 4,

              BES as 5,

              ALTI as 6,

              YEDI as 7,

              SEKIZ as 8,

              DOKUZ as 9,

              `ON` as 10,

              ONBIR as 11,

              ONIKI as 12,

              ONUC as 13,

              ONDORT as 14,

              ONBES as 15,

              ONALTI as 16,

              ONYEDI as 17,

              ONSEKIZ as 18,

              ONDOKUZ as 19,

              YIRMI as 20,

              YIRMIBIR as 21,

              YIRMIIKI as 22,

              YIRMIUC as 23,

              YIRMIDORT as 24,

              YIRMIBES as 25,

              YIRMIALTI as 26,

              YIRMIYEDI as 27,

              YIRMISEKIZ as 28,

              YIRMIDOKUZ as 29,

              OTUZ as 30,

              OTUZBIR as 31,

              OTUZIKI as 32,

              OTUZUC as 33,

              `BIR_2` as [1_2],

              `IKI_2` as [2_2],

              `UC_2` as [3_2],

              `DORT_2` as [4_2],

              `BES_2` as [5_2],

              `ALTI_2` as [6_2],

              `YEDI_2` as [7_2],

              `SEKIZ_2` as [8_2],

              `DOKUZ_2`as [9_2],

              `ON_2` as [10_2],

              `ONBIR_2` as [11_2],

              `ONIKI_2` as [12_2],

              `ONUC_2` as [13_2],

              `ONDORT_2` as [14_2],

              `ONBES_2` as [15_2],

              `ONALTI_2` as [16_2],

              `ONYEDİ_2` as [17_2],

              `ONSEKIZ_2` as [18_2],

              `ONDOKUZ_2` as [19_2],

              `YIRMI_2` as [20_2],

              `YIRMIBIR_2` as [21_2],

              `YIRMIIKI_2` as [22_2],

              `YIRMIUC_2` as [23_2],

              `YIRMIDORT_2` as [24_2],

              `YIRMIBES_2` as [25_2],

              `YIRMIALTI_2` as [26_2],

              `YIRMIYEDİ_2` as [27_2],

              `YIRMISEKIZ_2` as [28_2],

              `YIRMIDOKUZ_2` as [29_2],

              `OTUZ_2` as [30_2],

              `OTUZBIR_2` as [31_2],

              `OTUZIKI_2` as [32_2],

              `OTUZUC_2` as [33_2],

              A1 as A1_2,

              A2 as A2_2,

              A3 as A3_2,

              A4 as A4_2,

              B1 as B1_2,

              B2 as B2_2,

              B3 as B3_2,

              C1 as C1_2,

              C2 as C2_2,

              C3 as C3_2,

              C4 as C4_2,

              D1 as D1_2,

              D2 as D2_2,

              D3 as D3_2,

              D4 as D4_2,

             

          if(BIR='G',1,0) + if(IKI='G',1,0) + if(UC='G',1,0) + if(DORT='G',1,0) + if(BES='G',1,0)

              +if(ALTI='G',1,0) + if(YEDI='G',1,0) + if(SEKIZ='G',1,0) + if(DOKUZ='G',1,0) + if(ON='G',1,0)

              +if(ONBIR='G',1,0) + if(ONIKI='G',1,0) + if(ONUC='G',1,0) + if(ONDORT='G',1,0) + if(ONBES='G',1,0)

              +if(ONALTI='G',1,0) + if(ONYEDI='G',1,0) + if(ONSEKIZ='G',1,0) + if(ONDOKUZ='G',1,0) + if(YIRMI='G',1,0)

              +if(YIRMIBIR='G',1,0) + if(YIRMIIKI='G',1,0) + if(YIRMIUC='G',1,0) + if(YIRMIDORT='G',1,0) + if(YIRMIBES='G',1,0)

              +if(YIRMIALTI='G',1,0) + if(YIRMIYEDI='G',1,0) + if(YIRMISEKIZ='G',1,0) + if(YIRMIDOKUZ='G',1,0) + if(OTUZ='G',1,0)

              +if(OTUZBIR='G',1,0) + if(OTUZIKI='G',1,0) + if(OTUZUC='G',1,0) as [G Sayısı],

          if(BIR='VG',1,0) + if(IKI='VG',1,0) + if(UC='VG',1,0) + if(DORT='VG',1,0) + if(BES='VG',1,0)

              +if(ALTI='VG',1,0) + if(YEDI='VG',1,0) + if(SEKIZ='VG',1,0) + if(DOKUZ='VG',1,0) + if(ON='VG',1,0)

              +if(ONBIR='VG',1,0) + if(ONIKI='VG',1,0) + if(ONUC='VG',1,0) + if(ONDORT='VG',1,0) + if(ONBES='VG',1,0)

              +if(ONALTI='VG',1,0) + if(ONYEDI='VG',1,0) + if(ONSEKIZ='VG',1,0) + if(ONDOKUZ='VG',1,0) + if(YIRMI='VG',1,0)

              +if(YIRMIBIR='VG',1,0) + if(YIRMIIKI='VG',1,0) + if(YIRMIUC='VG',1,0) + if(YIRMIDORT='VG',1,0) + if(YIRMIBES='VG',1,0)

              +if(YIRMIALTI='VG',1,0) + if(YIRMIYEDI='VG',1,0) + if(YIRMISEKIZ='VG',1,0) + if(YIRMIDOKUZ='VG',1,0) + if(OTUZ='VG',1,0)

              +if(OTUZBIR='VG',1,0) + if(OTUZIKI='VG',1,0) + if(OTUZUC='VG',1,0) as [VG Sayısı],

          if(BIR='A',1,0) + if(IKI='A',1,0) + if(UC='A',1,0) + if(DORT='A',1,0) + if(BES='A',1,0)

              +if(ALTI='A',1,0) + if(YEDI='A',1,0) + if(SEKIZ='A',1,0) + if(DOKUZ='A',1,0) + if(ON='A',1,0)

              +if(ONBIR='A',1,0) + if(ONIKI='A',1,0) + if(ONUC='A',1,0) + if(ONDORT='A',1,0) + if(ONBES='A',1,0)

              +if(ONALTI='A',1,0) + if(ONYEDI='A',1,0) + if(ONSEKIZ='A',1,0) + if(ONDOKUZ='A',1,0) + if(YIRMI='A',1,0)

              +if(YIRMIBIR='A',1,0) + if(YIRMIIKI='A',1,0) + if(YIRMIUC='A',1,0) + if(YIRMIDORT='A',1,0) + if(YIRMIBES='A',1,0)

              +if(YIRMIALTI='A',1,0) + if(YIRMIYEDI='A',1,0) + if(YIRMISEKIZ='A',1,0) + if(YIRMIDOKUZ='A',1,0) + if(OTUZ='A',1,0)

              +if(OTUZBIR='A',1,0) + if(OTUZIKI='A',1,0) + if(OTUZUC='A',1,0)  as [A Sayısı],

          if(BIR='U',1,0) + if(IKI='U',1,0) + if(UC='U',1,0) + if(DORT='U',1,0) + if(BES='U',1,0)

              +if(ALTI='U',1,0) + if(YEDI='U',1,0) + if(SEKIZ='U',1,0) + if(DOKUZ='U',1,0) + if(ON='U',1,0)

              +if(ONBIR='U',1,0) + if(ONIKI='U',1,0) + if(ONUC='U',1,0) + if(ONDORT='U',1,0) + if(ONBES='U',1,0)

              +if(ONALTI='U',1,0) + if(ONYEDI='U',1,0) + if(ONSEKIZ='U',1,0) + if(ONDOKUZ='U',1,0) + if(YIRMI='U',1,0)

              +if(YIRMIBIR='U',1,0) + if(YIRMIIKI='U',1,0) + if(YIRMIUC='U',1,0) + if(YIRMIDORT='U',1,0) + if(YIRMIBES='U',1,0)

              +if(YIRMIALTI='U',1,0) + if(YIRMIYEDI='U',1,0) + if(YIRMISEKIZ='U',1,0) + if(YIRMIDOKUZ='U',1,0) + if(OTUZ='U',1,0)

              +if(OTUZBIR='U',1,0) + if(OTUZIKI='U',1,0) + if(OTUZUC='U',1,0) as [U Sayısı],

          if(BIR='SI',1,0) + if(IKI='SI',1,0) + if(UC='SI',1,0) + if(DORT='SI',1,0) + if(BES='SI',1,0)

              +if(ALTI='SI',1,0) + if(YEDI='SI',1,0) + if(SEKIZ='SI',1,0) + if(DOKUZ='SI',1,0) + if(ON='SI',1,0)

              +if(ONBIR='SI',1,0) + if(ONIKI='SI',1,0) + if(ONUC='SI',1,0) + if(ONDORT='SI',1,0) + if(ONBES='SI',1,0)

              +if(ONALTI='SI',1,0) + if(ONYEDI='SI',1,0) + if(ONSEKIZ='SI',1,0) + if(ONDOKUZ='SI',1,0) + if(YIRMI='SI',1,0)

              +if(YIRMIBIR='SI',1,0) + if(YIRMIIKI='SI',1,0) + if(YIRMIUC='SI',1,0) + if(YIRMIDORT='SI',1,0) + if(YIRMIBES='SI',1,0)

              +if(YIRMIALTI='SI',1,0) + if(YIRMIYEDI='SI',1,0) + if(YIRMISEKIZ='SI',1,0) + if(YIRMIDOKUZ='SI',1,0) + if(OTUZ='SI',1,0)

              +if(OTUZBIR='SI',1,0) + if(OTUZIKI='SI',1,0) + if(OTUZUC='SI',1,0) as [SI Sayısı],

          if(BIR='NA',1,0) + if(IKI='NA',1,0) + if(UC='NA',1,0) + if(DORT='NA',1,0) + if(BES='NA',1,0)

              +if(ALTI='NA',1,0) + if(YEDI='NA',1,0) + if(SEKIZ='NA',1,0) + if(DOKUZ='NA',1,0) + if(ON='NA',1,0)

              +if(ONBIR='NA',1,0) + if(ONIKI='NA',1,0) + if(ONUC='NA',1,0) + if(ONDORT='NA',1,0) + if(ONBES='NA',1,0)

              +if(ONALTI='NA',1,0) + if(ONYEDI='NA',1,0) + if(ONSEKIZ='NA',1,0) + if(ONDOKUZ='NA',1,0) + if(YIRMI='NA',1,0)

              +if(YIRMIBIR='NA',1,0) + if(YIRMIIKI='NA',1,0) + if(YIRMIUC='NA',1,0) + if(YIRMIDORT='NA',1,0) + if(YIRMIBES='NA',1,0)

              +if(YIRMIALTI='NA',1,0) + if(YIRMIYEDI='NA',1,0) + if(YIRMISEKIZ='NA',1,0) + if(YIRMIDOKUZ='NA',1,0) + if(OTUZ='NA',1,0)

              +if(OTUZBIR='NA',1,0) + if(OTUZIKI='NA',1,0) + if(OTUZUC='NA',1,0) as [NA Sayısı],

          if(BIR_2='KOS',1,0) + if(IKI_2='KOS',1,0) + if(UC_2='KOS',1,0) + if(DORT_2='KOS',1,0) + if(BES_2='KOS',1,0)

              +if(ALTI_2='KOS',1,0) + if(YEDI_2='KOS',1,0) + if(SEKIZ_2='KOS',1,0) + if(DOKUZ_2='KOS',1,0) + if(ON_2='KOS',1,0)

              +if(ONBIR_2='KOS',1,0) + if(ONIKI_2='KOS',1,0) + if(ONUC_2='KOS',1,0) + if(ONDORT_2='KOS',1,0) + if(ONBES_2='KOS',1,0)

              +if(ONALTI_2='KOS',1,0)  + if(ONSEKIZ_2='KOS',1,0) + if(ONDOKUZ_2='KOS',1,0) + if(YIRMI_2='KOS',1,0)

              +if(YIRMIBIR_2='KOS',1,0) + if(YIRMIIKI_2='KOS',1,0) + if(YIRMIUC_2='KOS',1,0) + if(YIRMIDORT_2='KOS',1,0) + if(YIRMIBES_2='KOS',1,0)

              +if(YIRMIALTI_2='KOS',1,0)  + if(YIRMISEKIZ_2='KOS',1,0) + if(YIRMIDOKUZ_2='KOS',1,0) + if(OTUZ_2='KOS',1,0)

              +if(OTUZBIR_2='KOS',1,0) + if(OTUZIKI_2='KOS',1,0) + if(OTUZUC_2='KOS',1,0) as [KOS Sayısı],

          if(BIR_2='UOA',1,0) + if(IKI_2='UOA',1,0) + if(UC_2='UOA',1,0) + if(DORT_2='UOA',1,0) + if(BES_2='UOA',1,0)

              +if(ALTI_2='UOA',1,0) + if(YEDI_2='UOA',1,0) + if(SEKIZ_2='UOA',1,0) + if(DOKUZ_2='UOA',1,0) + if(ON_2='UOA',1,0)

              +if(ONBIR_2='UOA',1,0) + if(ONIKI_2='UOA',1,0) + if(ONUC_2='UOA',1,0) + if(ONDORT_2='UOA',1,0) + if(ONBES_2='UOA',1,0)

              +if(ONALTI_2='UOA',1,0) + if(ONSEKIZ_2='UOA',1,0) + if(ONDOKUZ_2='UOA',1,0) + if(YIRMI_2='UOA',1,0)

              +if(YIRMIBIR_2='UOA',1,0) + if(YIRMIIKI_2='UOA',1,0) + if(YIRMIUC_2='UOA',1,0) + if(YIRMIDORT_2='UOA',1,0) + if(YIRMIBES_2='UOA',1,0)

              +if(YIRMIALTI_2='UOA',1,0) + if(YIRMISEKIZ_2='UOA',1,0) + if(YIRMIDOKUZ_2='UOA',1,0) + if(OTUZ_2='UOA',1,0)

              +if(OTUZBIR_2='UOA',1,0) + if(OTUZIKI_2='UOA',1,0) + if(OTUZUC_2='UOA',1,0) as [UOA Sayısı],

          if(BIR_2='MAC',1,0) + if(IKI_2='MAC',1,0) + if(UC_2='MAC',1,0) + if(DORT_2='MAC',1,0) + if(BES_2='MAC',1,0)

              +if(ALTI_2='MAC',1,0) + if(YEDI_2='MAC',1,0) + if(SEKIZ_2='MAC',1,0) + if(DOKUZ_2='MAC',1,0) + if(ON_2='MAC',1,0)

              +if(ONBIR_2='MAC',1,0) + if(ONIKI_2='MAC',1,0) + if(ONUC_2='MAC',1,0) + if(ONDORT_2='MAC',1,0) + if(ONBES_2='MAC',1,0)

              +if(ONALTI_2='MAC',1,0)  + if(ONSEKIZ_2='MAC',1,0) + if(ONDOKUZ_2='MAC',1,0) + if(YIRMI_2='MAC',1,0)

              +if(YIRMIBIR_2='MAC',1,0) + if(YIRMIIKI_2='MAC',1,0) + if(YIRMIUC_2='MAC',1,0) + if(YIRMIDORT_2='MAC',1,0) + if(YIRMIBES_2='MAC',1,0)

              +if(YIRMIALTI_2='MAC',1,0) + if(YIRMISEKIZ_2='MAC',1,0) + if(YIRMIDOKUZ_2='MAC',1,0) + if(OTUZ_2='MAC',1,0)

              +if(OTUZBIR_2='MAC',1,0) + if(OTUZIKI_2='MAC',1,0) + if(OTUZUC_2='MAC',1,0) as [MAC Sayısı],

          if(BIR_2='OMA',1,0) + if(IKI_2='OMA',1,0) + if(UC_2='OMA',1,0) + if(DORT_2='OMA',1,0) + if(BES_2='OMA',1,0)

              +if(ALTI_2='OMA',1,0) + if(YEDI_2='OMA',1,0) + if(SEKIZ_2='OMA',1,0) + if(DOKUZ_2='OMA',1,0) + if(ON_2='OMA',1,0)

              +if(ONBIR_2='OMA',1,0) + if(ONIKI_2='OMA',1,0) + if(ONUC_2='OMA',1,0) + if(ONDORT_2='OMA',1,0) + if(ONBES_2='OMA',1,0)

              +if(ONALTI_2='OMA',1,0)  + if(ONSEKIZ_2='OMA',1,0) + if(ONDOKUZ_2='OMA',1,0) + if(YIRMI_2='OMA',1,0)

              +if(YIRMIBIR_2='OMA',1,0) + if(YIRMIIKI_2='OMA',1,0) + if(YIRMIUC_2='OMA',1,0) + if(YIRMIDORT_2='OMA',1,0) + if(YIRMIBES_2='OMA',1,0)

              +if(YIRMIALTI_2='OMA',1,0) + if(YIRMISEKIZ_2='OMA',1,0) + if(YIRMIDOKUZ_2='OMA',1,0) + if(OTUZ_2='OMA',1,0)

              +if(OTUZBIR_2='OMA',1,0) + if(OTUZIKI_2='OMA',1,0) + if(OTUZUC_2='OMA',1,0) as [OMA Sayısı],

          if(BIR_2='OMB',1,0) + if(IKI_2='OMB',1,0) + if(UC_2='OMB',1,0) + if(DORT_2='OMB',1,0) + if(BES_2='OMB',1,0)

              +if(ALTI_2='OMB',1,0) + if(YEDI_2='OMB',1,0) + if(SEKIZ_2='OMB',1,0) + if(DOKUZ_2='OMB',1,0) + if(ON_2='OMB',1,0)

              +if(ONBIR_2='OMB',1,0) + if(ONIKI_2='OMB',1,0) + if(ONUC_2='OMB',1,0) + if(ONDORT_2='OMB',1,0) + if(ONBES_2='OMB',1,0)

              +if(ONALTI_2='OMB',1,0)  + if(ONSEKIZ_2='OMB',1,0) + if(ONDOKUZ_2='OMB',1,0) + if(YIRMI_2='OMB',1,0)

              +if(YIRMIBIR_2='OMB',1,0) + if(YIRMIIKI_2='OMB',1,0) + if(YIRMIUC_2='OMB',1,0) + if(YIRMIDORT_2='OMB',1,0) + if(YIRMIBES_2='OMB',1,0)

              +if(YIRMIALTI_2='OMB',1,0) + if(YIRMISEKIZ_2='OMB',1,0) + if(YIRMIDOKUZ_2='OMB',1,0) + if(OTUZ_2='OMB',1,0)

              +if(OTUZBIR_2='OMB',1,0) + if(OTUZIKI_2='OMB',1,0) + if(OTUZUC_2='OMB',1,0) as [OMB Sayısı]