4 Replies Latest reply: Oct 12, 2010 9:55 AM by CraigB RSS

    FRM-40301

    vikas singhal
      HI

      i have a master with two detail form

      but i addes a coloumn in detail after that when i enter_query and then execute_query then the error frm-40301

      please guide where i will check


      thanks
      vikas
        • 1. Re: FRM-40301
          Ahmed
          you added a column in detail .. ARe you sure this column is exist in your table.

          I think this column is not in your table due to this error showing.
          • 2. Re: FRM-40301
            vikas singhal
            i had checked but
            not find anything

            regards
            vikas
            • 3. Re: FRM-40301
              AmmadAhmed
              Hello,
              FRM-40301: Query caused no records to be retrieved. Re-enter.
              Possible reasons for this error.

              - Table is not having entry.
              - The search criteria which you are entering is not having any data in table.
              - Any list item/checkbox/radio item (added) is having not having any values which is in the table.

              -Ammad
              • 4. Re: FRM-40301
                CraigB
                Vikas,
                Bring up the "Display Error" screen (10g: Shift + Ctrl + E or 6i: Shift + F1) and copy the SQL Query to SQLPlus and run there. Typically, this will show you why you are getting no rows returned.

                Hope this helps,
                Craig B-)

                If someone's response is helpful or correct, please mark it accordingly.