editing without rowid

[jdorlon]

Hello,

I have this sql in a TSmartquery connected to a grid.

Code: Select all

select /*+ FULL(Tbl1)  */
       EMPNO, ENAME, JOB, MGR, HIREDATE
       , SAL, COMM, DEPTNO
from   JDORLON.EMP Tbl1
minus
select /*+ FULL(Tbl2)  */
       EMPNO, ENAME, JOB, MGR, HIREDATE
       , SAL, COMM, DEPTNO
from   SCOTT.EMP Tbl2

When I tried to edit the grid, it worked even though I have not selected a ROWID!

This query was used when I changed a value in the EMPNO column:

Code: Select all

UPDATE JDORLON.EMP
SET
  EMPNO = :EMPNO
WHERE
  EMPNO = :Old_EMPNO

How can I disable this behavior in ODAC?

Thanks,

-John

[Plash]

You can only manually check if ROWID field is present in the fields list, and set the ReadOnly property to True, if this field is not present.