4 Replies Latest reply: Dec 27, 2012 5:31 AM by Naamas RSS

    validation in version 4.2

    Naamas
      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
          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
            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
              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
                Thank you