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'
로그인 필요
프리미엄 기술 문서를 보려면 로그인해야 하며 최신 유지 관리 계약이 있어야 합니다.