home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.oracle
- Path: sparky!uunet!centerline!sebastian.centerline.com!user
- From: dewey@centerline.com (Devan F. Dewey)
- Subject: Re: Forms3 ERR - unable to INSERT record
- Message-ID: <dewey-220792114200@sebastian.centerline.com>
- Followup-To: comp.databases.oracle
- Sender: news@centerline.com
- Nntp-Posting-Host: sebastian
- Organization: CenterLine Software, Inc.
- References: <1992Jul22.105329.244@falcon.navsses.navy.mil>
- Date: Wed, 22 Jul 1992 15:43:17 GMT
- Lines: 26
-
- 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
-