| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cannot update or edit in a view -- question
What is the front end? I've seen cases in Delphi and VB where the user tries to modify a field in a grid, but the underlying query is a view... Oracle interprets it as someone trying to modify a field and reports the error. It may be something as simple as removing the 'editing' capability from that particular gui screen.
Nick
-----Original Message-----
From: Steve McClure [mailto:smcclure_at_usscript.com]
Sent: Monday, January 07, 2002 12:11 PM
To: Multiple recipients of list ORACLE-L
Subject: cannot update or edit in a view -- question
Hello all,
Last night I migrated our last production database from 7.3.4 to 8i. Things
have gone quite well so far, but I have just been notified that some of our
clients are receiving the above error while trying to issue updates.
My initial queries into this haven't been very fruitful, so I am taking the time to tap into your knowledge while I keep digging. To briefly state the problem. We have business clients that have remote access to our database. We use views to limit their access to records that are directly related to their individual organizations. Today, after the 8i conversion they are receiving the "Cannot update or edit from a view" error message. I haven't gotten the error number yet. In fact that is my next step. If I can identify the exact error message, perhaps I can rtfm.
Thanks in advance for any responses.
Steve McClure
Duhveloper slowly evolving into a DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: smcclure_at_usscript.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 07 2002 - 14:53:01 CST
 |
 |