This discussion is archived
4 Replies Latest reply: Dec 27, 2012 3:31 AM by Naamas RSS

validation in version 4.2

Naamas Newbie
Currently Being Moderated
Hi all,
The last version of Apex that i've worked with was 3.1
Now i have 4.2 version. i've create page -> form-> -> form on table with report ,( such as sample application interactive report)
when i'm in the interactive report page and i'm pressing the edit of some record -> i'm getting a DML Form page.
my form is based on table employees in schema HR.
desc employees
CREATE TABLE EMPLOYEES
(
  EMPLOYEE_ID     NUMBER(6),
  FIRST_NAME      VARCHAR2(20 BYTE),
  LAST_NAME       VARCHAR2(25 BYTE) CONSTRAINT EMP_LAST_NAME_NN NOT NULL,
  EMAIL           VARCHAR2(25 BYTE) CONSTRAINT EMP_EMAIL_NN NOT NULL,
  PHONE_NUMBER    VARCHAR2(20 BYTE),
  HIRE_DATE       DATE CONSTRAINT EMP_HIRE_DATE_NN NOT NULL,
  JOB_ID          VARCHAR2(10 BYTE) CONSTRAINT EMP_JOB_NN NOT NULL,
  SALARY          NUMBER(8,2),
  COMMISSION_PCT  NUMBER(2,2),
  MANAGER_ID      NUMBER(6),
  DEPARTMENT_ID   NUMBER(4))
the apex force the user to insert values for the fields which suppose to be with value.
if the user is not entering value , the validation is raised,
i looking in the page at Page Processing -> validation . and i cannot see any validation,
i do not understand from which place the validation is raised ,
please you help
Naama
  • 1. Re: validation in version 4.2
    fac586 Guru
    Currently Being Moderated
    Naamas wrote:

    the apex force the user to insert values for the fields which suppose to be with value.
    if the user is not entering value , the validation is raised,
    i looking in the page at Page Processing -> validation . and i cannot see any validation,
    i do not understand from which place the validation is raised ,
    These validations are performed automatically by APEX when the Value Required property in a page item's definition is set to Yes.
  • 2. Re: validation in version 4.2
    Naamas Newbie
    Currently Being Moderated
    Hi Paul,
    Thanks for the response ,
    It works!
    can you please direct me where can i found about all these features ?
    should i read all the new features of every release , or is there one document which contains all the features ?
    Thanks In Advanced
    Naama
  • 3. Re: validation in version 4.2
    fac586 Guru
    Currently Being Moderated
    Naamas wrote:
    Hi Paul,
    Thanks for the response ,
    It works!
    can you please direct me where can i found about all these features ?
    should i read all the new features of every release , or is there one document which contains all the features ?
    Read the New Features documentation (and Release Notes) for every release. There's no single cumulative document.
  • 4. Re: validation in version 4.2
    Naamas Newbie
    Currently Being Moderated
    Thank you

Legend

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