11 Replies Latest reply: Jun 20, 2013 11:16 PM by niceali RSS

    list item and text item in oracle form 6i

    niceali

      there are two tables emp and file_ref.

      a text item manually add and pop list.

      i want when i select a from poplist. text item show the a column of file_ref table.

      and when i select b from poplist it show b column from file_ref.

      i use trigger

      when-list-changed.

      and query is

      begin

      if :emp.fileno = 11 and :emp.pop_list= 'A' Then

      select A into :file_ref.filename

      from file_ref

      where empcode = '10';

      end if ;

      end;

      the problem i am facing is that.

      when i execute query system show no data.

      please help me. and tell me what kind of settings are required in items property for this task.

      i will wait for your replies.

       

      Thanks

        • 1. Re: list item and text item in oracle form 6i
          Abbas85

          Hi..

          tell me somethings like:

           

          How many values are in your list? only A and B?

           

          and what exactly you want show..If select A then what? or if select B then what?

           

          and where you want to display your output?

           

          How you add those A ,B ,..etc values in poplist?if you add manually then have gave right mappings to them?

           

           

          Thanks....

          • 2. Re: list item and text item in oracle form 6i
            niceali

            Thanks to reply me brother.

            Brother, pop list is not a database item. let me explain what i want.

            My project is computerized file system

            i have two table emp and file_ref.

            the employee's code and employee personal official file no in emp table.

            and file_ref table consist employee personal official file no. if it is letter like appointment

            letter, transfer letter etc.will be in letter column. if it is order like increment order etc it will be in order column.

            the purpose of this project is when user enter employee code and file fileno. and he want to see an appointment letter of this employee. he select word "letter" in poplist and all letters against particular employee should be appear in text items and he select on appointment letter and click the button view file and the scan paper of appointment letter of that employee should be open in pdf.

            I want your help that how it will be possible if a user select "letter"from pop list and column name letter from table file_ref appear in text items similarly he select "order" and the column name order from table file_ref appear in text items.

            Thanks

            God Bless You

            • 3. Re: list item and text item in oracle form 6i
              mostafiz mitul

              Hi..........................

              i'm a newbie.............

              therefore my answer should b like newbie.........................

              pardon me 4 that.............................

               

              #1. first value of list item should be 'A' for visible or label A.......... and value 'B' for label 'B'

              #2. secondly u've to change list item .... that is if A is visible ... change it to B.... as a result when-list-changed trigger will execute.

              #3.  if all the above is correct therefore <<if :emp.fileno = 11 and :emp.pop_list= 'A' Then>> this condition is not full filing its criteria .....

               

               

              thanks

              mostafiz mitul

              (newbie)

              • 4. Re: list item and text item in oracle form 6i
                niceali

                Thanks to reply me brother.

                Brother, pop list is not a database item. let me explain what i want.

                My project is computerized file system

                i have two table emp and file_ref.

                the employee's code and employee personal official file no in emp table.

                and file_ref table consist employee personal official file no. if it is letter like appointment

                letter, transfer letter etc.will be in letter column. if it is order like increment order etc it will be in order column.

                the purpose of this project is when user enter employee code and file fileno. and he want to see an appointment letter of this employee. he select word "letter" in poplist and all letters against particular employee should be appear in text items and he select on appointment letter and click the button view file and the scan paper of appointment letter of that employee should be open in pdf.

                I want your help that how it will be possible if a user select "letter"from pop list and column name letter from table file_ref appear in text items similarly he select "order" and the column name order from table file_ref appear in text items.

                Thanks

                God Bless You

                • 5. Re: list item and text item in oracle form 6i
                  mostafiz mitul

                  thanks.............

                  now it becomes interesting................................

                  as u describe ... i dont know how much i can realize.........

                  ............................

                  table name <file_ref>

                  u've a column named letter => data of this field can be appointment letter , transfer letter and so on , with relation of an employee id

                  u've another column named order => data of this field can be increment order and so on, with relation of an employee id

                   

                  and now depends upon user request

                  <<column name order from table file_ref appear in text items.>>

                  is it

                   

                   


                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                   

                  --------------------------------------------------------------------

                  may b even this one is not perfect solution 4 u

                  -------------------------------------------------------------------

                  when-list-changed.

                  and query is

                  begin

                  if :emp.fileno = 11 and :emp.pop_list= 'A' Then

                       declare

                            cursor c1 is

                            select order from file_ref

                            where empcode = '10';

                       begin

                            clear_block(no_validate);

                            for r1 in c1 loop

                                 :file_ref.filename := r1.order;

                                 next_record;

                            end loop;

                            first_record;

                       end;

                  elsif :emp.fileno = 11 and :emp.pop_list= 'B' Then

                       declare

                            cursor c1 is

                            select letter from file_ref

                            where empcode = '10';

                       begin

                            clear_block(no_validate);

                            for r1 in c1 loop

                                 :file_ref.filename := r1.letter;

                                 next_record;

                            end loop;

                            first_record;

                       end;

                  elsif ..........so..on...........so..on.......so..on then

                       so...on;

                  end if;

                  end;

                  --------------------------------------------------------------------------

                  i dont know will it b help full 4 u

                  --------------------------------------------------------------------------

                  if u give me a chance using teamviewer .... therefore i can try it more

                  (it's an unofficial talking)

                   

                   

                  thanks..........

                  mostafiz mitul

                  • 6. Re: list item and text item in oracle form 6i
                    niceali

                    Thanks Mostafiz,

                    when i click on execute query and select letter option from pop list. the message appear again and again.

                    Do you want to save changes you made.

                    but when i select order whole form blank and just show message.

                    Do you want to save changes you made.

                    • 7. Re: list item and text item in oracle form 6i
                      mostafiz mitul

                      actual y .......... i've to clear which one is ur database block and which one is not.........

                      u can use here :system.block_staus..............

                      if u r able to provide teamviewer connection then it will be clear for me...

                       

                      thanks

                      mostafiz mitul

                      • 8. Re: list item and text item in oracle form 6i
                        Abbas85

                        I think its a duplicate post you have posted

                         

                        see below:

                         

                        https://forums.oracle.com/thread/2547793

                        • 9. Re: list item and text item in oracle form 6i
                          niceali

                          sir  mostafiz

                           

                          i am on team viewer. can u give me your email id

                          i will send you team viewer id and password please

                          • 10. Re: list item and text item in oracle form 6i
                            mostafiz mitul

                            i'm extremely sorry

                            i cant response u timely

                             

                            mostafiz mitul

                            mostafizmitul07@gmail.com

                            • 11. Re: list item and text item in oracle form 6i
                              niceali

                              Sir

                              Please check your mail box. i sent a mail