Updateable button is ON, but it still shows as "Data Set is Read-Only" when the WHERE clause is i
説明
Updateable button is ON, but it still shows as "Data Set is Read-Only" when the WHERE clause is in the same line as the FROM clause. If I move the WHERE clause to the next line or add "a.rowid" in the end of the column name list in the query statement, it will state "Data Set is Updateable" and I will be able to update the data results.
Example script that encounters the issue:
SELECT a.cust_no, a.first, a.last, a.state, a.zip,
a.street, a.city, a.dob, a.balance, a.cr_limit
FROM customer a WHERE a.state = 'CA'
対策
WORAROUND 1:
Place the WHERE clause in the next line or separate line from the FROM clause.
Example:
SELECT a.cust_no, a.first, a.last, a.state, a.zip,
a.street, a.city, a.dob, a.balance, a.cr_limit
FROM customer a
WHERE a.state = 'CA'
WORAROUND 2:
Add "a.rowid" in the end of the column names list in the query statement.
Example:
SELECT a.cust_no, a.first, a.last, a.state, a.zip,
a.street, a.city, a.dob, a.balance, a.cr_limit, a.rowid
FROM customer a WHERE a.state = 'CA'
WORAROUND 3:
Add extra spaces (two or more) before the WHERE clause.
Example:
SELECT a.cust_no, a.first, a.last, a.state, a.zip,
a.street, a.city, a.dob, a.balance, a.cr_limit
FROM customer a WHERE a.state = 'CA'
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle.
Defect ID
ST7803
追加情報
See also Solution SOL56716 for the original problem [Updateable button is ON, but still shows as "Data Set is Read-Only" when table column name is similar to a reserved word].
