4 Replies Latest reply: Feb 5, 2011 5:46 AM by vee RSS

    Validation Configuration

    716243
      Is there a way to configure Form validations in bulk, instead of configuring one at a time? Thanks.

      Shikhar
        • 1. Re: Validation Configuration
          peter_raganitsch
          Hi Shikhar,

          when you say "define in bulk" do you mean define multiple item validations at once? In this case the answer is no.

          If you refer to validations on form level instead of item level, then the answer is yes. Form Validations run after all item validations and can be of type PL/SQL where you can check whatever you need.

          brgds,
          Peter

          Blog: http://www.oracle-and-apex.com
          • 2. Re: Validation Configuration
            Binepal
            is this what you are looking for.......

            Home>Application Builder>Application 257>Page 1>Create Validation

            in page definition in the middle section "Page Processing" click on + icon next to Validations


            then click on link at bottom

            Create Multiple, not null validations
            • 3. Re: Validation Configuration
              837127
              hi binepal,

              i didn't find any link at bottom. (Create Multiple, not null validations)

              how can i do this??

              thanks
              • 4. Re: Validation Configuration
                vee
                I think "multiple not null validations" were available in apex 3.2 , don't remember seeing it in apex 4.0.

                <li>If you are on Apex 4.0, you don't need to create not null validations separately for items, you can set that at the item level itself.
                Go to Item Properties -> Settings section -> Value Required. This would automatically cause a validation to be performed on that item.


                Else you can create a page validation and use an SQL expression like
                     :ITEM2 IS NOT NULL
                 OR :ITEM2 IS NOT NULL
                 OR :ITEM3 IS NOT NULL