3 Replies Latest reply: Apr 18, 2013 9:42 AM by SharonDee RSS

    Form on a SQL Query

      Hi there,

      I've created a "Form on a SQL Query" using the example database and query example:

      select e.empno, e.ename, e.job, e.hiredate, e.sal, d.dname
      from emp e, dept d
      where e.deptno = d.deptno

      which works fine. But suppose I want to modify the query? Where can I find it? Or is the only thing you can do is to delete the form region (and corresponding items and buttons) and start all over again?