Re: Forms3 ERR - unable to INSERT record

In article <1992Jul22.105329.244_at_falcon.navsses.navy.mil>, huynh_at_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_at_centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya