Updateable button is ON, but it still shows as "Data Set is Read-Only" when the WHERE clause is i (4295203)

Chatee ahora con Soporte

Obtener ayuda en vivo
Completar registro

Iniciar sesión

Solicitar precios

Comuníquese con Ventas

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Updateable button is ON, but it still shows as "Data Set is Read-Only" when the WHERE clause is i
Descripción

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'
Resolución

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 de defecto

ST7803
Información adicional

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].

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Solicitar un artículo KB

Contenido recomendado

Producto(s):: SQL Navigator for Oracle
6.2.1

Tema(s):: Technical Solutions

Historial del artículo:: Creado el: 1/26/2010
Última actualización: 5/7/2023

Buscar todos los artículos

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Updateable button is ON, but it still shows as "Data Set is Read-Only" when the WHERE clause is i (4295203)

Título

Descripción

Resolución

ID de defecto

Información adicional

Leave a Comment