This discussion is archived
4 Replies Latest reply: Feb 5, 2011 3:46 AM by vee RSS

Validation Configuration

716243 Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points