6 Replies Latest reply: Mar 6, 2014 5:49 AM by Nilesh Goswami RSS

    field must be entered

    2616579

      hi

      iam getting a error like 'feild must be enter' in my task.my task is

      first get a department table.it consist of two coloums they are deptnum,dname.and then that dept table goes to canvas.in canvas i created a new frame  it consist one text_item and push_button.in text item i have to enter deptnum and press the push button.automatically the deptnum,dname have to displayed.but iam getting error like feild must be entered. any one help me please

       

       

      push_button code:when_button_pressed: go_block('DEPT');

                                                                     execute_query;

       

      thanks&regards

      karthik.

        • 1. Re: field must be entered
          Soofi

          Hi Karthik,

          Make the required Property set to 'NO'  in your deptnum field.

           

           

          Regards,

          Soofi

          • 2. Re: field must be entered
            AnnPricks E

            Hi...

            'feild must be enter' error comes because of you set that textitem required property as "YES".. So you need to enter some value in that else you have to change the property as "NO".. If enter some value in the textitem then you can able to press the button

            • 3. Re: field must be entered
              Andreas Weiden

              To query for specific values you have to go in enter-query-modus, then enter the search criteria, then execute the query.

              So you might have a "Start search"-button which does an ENTER_QUERY; After that the user can enter his search criteria. On the "Execute Search"-button you then put a simple EXECUTE_QUERY;

              • 4. Re: field must be entered
                2616579

                if i set property as NO again it ask "do you want to save the changes you made".but i wont get dept detals.........

                • 5. Re: field must be entered
                  AnnPricks E

                  Just now i tried your solution.. I am telling the step for what i did

                  Step 1:-

                  ---------

                  CREATE one canvas

                  CREATE two blocks(one database block, one control block).


                  Control Block:-

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

                  Set the property for control block

                  PROPERTY:-

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

                  1) Database datablock ---> NO

                  CREATE one text item and one button in control block

                   

                  CREATE 2 items

                  1) deptno1

                  2) button

                  Trigger:-

                  When button pressed:-

                  GO_BLOCK('BLOCK5');

                  EXECUTE_QUERY;



                  Database Block:-

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

                  Set the property for database block

                  CREATE 2 items in database block

                  Query datasource name --> dept

                  Query datasource columns ---> Add deptno NUMBER(10),

                                                                      dname VARCHAR2(20)

                  Where clause --> deptno = :BLOCK4(your controlblock).DEPTNO1

                  1) deptno

                  Property:-

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

                  1) database item --> YES

                  2) column name --> deptno

                   

                  2) dname

                  Property:-

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

                  1) database item --> YES

                  2) column name --> deptno

                  Try like this and let me know in case of any issues

                  • 6. Re: field must be entered
                    Nilesh Goswami

                    Hi,

                     

                    Steps to create a form which will fulfill your requirements:

                     

                    1. Create a control block:

                         Properties to set:

                    • Database Data Block : NO

                         Create two items in this block

                    • Text item (For search crieteria)
                    • Push Button (To find data)

                    2. Create second Block which will be data block:

                         Properties to set:

                    • Database Data Block : Yes
                    • Query Data Source Name : Dept (Table name for department)
                    • Where Clause : deptno (department number column) = :control_block.text_item (search item)

                         Create two items in this block.

                    • Deptno (For department Number)
                      • Database Item: Yes
                      • Column Name: Deptno ( column name for the department number)
                    • Dname (For department Name)
                      • Database Item: Yes
                      • Column Name: Deptno ( column name for the department number)

                    3. Trigger in the push button

                         Go_block('DEPT'); "(created database block)"

                         Execute_Query;

                     

                    Note: Sequence of the control block should be before than the database block for the department in the list.

                     

                    Hope this will help you..

                     

                    Regards,

                    Nilesh Goswami.