home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.oracle
- Path: sparky!uunet!munnari.oz.au!bunyip.cc.uq.oz.au!cheops!scammell!srh
- From: srh@scammell.ecos.tne.oz.au (Shane Hocking)
- Subject: Re: Forms3 ERR - unable to INSERT record
- Message-ID: <1992Jul22.232706.17890@scammell.ecos.tne.oz.au>
- Organization: Telecom Australia, Information Technology Development
- References: <1992Jul22.105329.244@falcon.navsses.navy.mil> <dewey-220792114200@sebastian.centerline.com>
- Date: Wed, 22 Jul 1992 23:27:06 GMT
- Lines: 17
-
- >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.
- >
- >
- You can use forms to insert, update, or delete data through a view (defined
- as a base table in forms) even if that view is a multi table join. You must
- however control the locking , inserting,updating and deleting through the
- following triggers. ON-LOCK,ON-INSERT, ON-UPDATE & ON-DELETE.
- This is a useful feature in Client-Server programming to minimise the
- number of packets required to display a "block" of information.
-
- --
- Shane Hocking srh@scammell.ecos.tne.oz.au
-