9 Replies Latest reply: Jun 15, 2013 6:31 AM by LT.ora RSS

    Add Text Item on Param Form

    LT.ora

      Forms [32 Bit] Version 10.1.2.0.2  Query:

       

      Need to Create a dynamic form (search parameter form)

      where the user can enter the value for specified Parameter

      for that I need to Add Text Item on Param Form

      just like we can Enter Binds in a Query Builder


      for e.g. if we query for :

      SELECT SCOTT.EMP.ENAME,
        SCOTT.EMP.JOB,
        SCOTT.DEPT.DNAME
      FROM SCOTT.DEPT
      INNER JOIN SCOTT.EMP
      ON SCOTT.DEPT.DEPTNO = SCOTT.EMP.DEPTNO
      WHERE SCOTT.DEPT.LOC = :location
      AND SCOTT.EMP.SAL    > :salary
      AND SCOTT.EMP.COMM  >= :commission 
      

       

      the Query Builder ask for 3 Binds :location, :salary, :commission