home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!decwrl!oracle!unrepliable!bounce
- Newsgroups: comp.databases.oracle
- From: dbmoore@us.oracle.com (Dennis Moore)
- Subject: Re: Forms3 ERR - unable to INSERT record
- Message-ID: <1992Jul25.022206.12578@oracle.us.oracle.com>
- Summary: ON-INSERT, -UPDATE, -DELETE triggers
- Sender: usenet@oracle.us.oracle.com (Oracle News Poster)
- Nntp-Posting-Host: hqsun4.us.oracle.com
- Organization: not an official statement of Oracle Corporation, Redwood Shores CA
- References: <1992Jul22.105329.244@falcon.navsses.navy.mil> <dewey-220792114200@sebastian.centerline.com>
- Date: Sat, 25 Jul 1992 02:22:06 GMT
- X-Disclaimer: This message was written by an unauthenticated user
- at Oracle Corporation. The opinions expressed are those
- of the user and not necessarily those of Oracle.
- Lines: 36
-
- In article <dewey-220792114200@sebastian.centerline.com> dewey@centerline.com (Devan F. Dewey) writes:
- >In article <1992Jul22.105329.244@falcon.navsses.navy.mil>,
- >huynh@falcon.navsses.navy.mil wrote:
- >>
- >> Greetings,
- >> thanks for reading.
- >> I am doing a project on SQLFORMS version 3.0. The project is simply to join
- >> three tables in addition with a new one.
- >>
- >> For every execution, after hitting the commit key, I keep getting the error:
- >> FRM 40508 : ORACLE ERROR -- unable to INSERT record
- >>
- >> Any suggestions would be appreciated. Many thanks.
- >
- >You cannot use Forms to insert or update data in a view. Forms acutally
- >uses the rowid field when performing these tasks and there is no rowid
- >field for a view. Views are only useful for query only blocks.
- >
- >You are going to have to break up the blocks so that the block you which to
- >insert from has a base table which is a true table, not a view.
- >
- >
- > Devan F. Dewey | Senior Systems Analyst
- > CenterLine Software | dewey@centerline.com
- > 10 Fawcett Street | "Leme esplain - no dere is
- > Cambridge, MA 02138 | too much. Leme sum up."
- > -Inigo Montoya
-
- Actually, see the manual sections on the ON-INSERT, ON-UPDATE, and ON-DELETE.
- These triggers are specifically useful for updating through views.
- Incidentally, the fact that Forms uses ROWID has nothing to do with updating
- or inserting into views based on multiple tables -- this is a SQL restriction.
-
- Good luck!
-
- -- Dennis Moore, my own opinions, etcetcetc
-