Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
결함 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].
