Toad World® Forums

Should be Updateable


#1

this sql is updateable:

SELECT c.*
FROM cost_acct c, vhcl v
WHERE v.vhcl_intr_no = c.vhcl_intr_no;

this isn’t:

SELECT c.–, v.
FROM cost_acct c, vhcl v
WHERE v.vhcl_intr_no = c.vhcl_intr_no;


#2

Hi Joe,

We need to fix this so Nav would behave consistently in both cases. However, whether this statement should be updateable or not is another matter. I had a look at the help file and it turns out there are some restrictions on Updateable queries. They must be simple select statements (no joins, sub queries, calculated field, etc.)
If you run both of these queries in 5.5, none of them is updateable. Somehow, we didn’t apply any restrictions in 6.0 and 6.1. This will need more investigation.

Thanks for pointing this out to us.
Gwen