Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    london
    Posts
    10

    Unanswered: FRM-40602: Cannot insert into or update data in a view

    Can anyone please help me with this error:

    FRM-40602: Cannot insert into or update data in a view

    I keep getting it when i try to update a view on form9i's web frontend.
    I can update the view without a problem through sql.

    Any help would be greatly appreciated.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: FRM-40602: Cannot insert into or update data in a view

    As I recall this is a limitation in Forms. What you can do is define ON-LOCK, ON-INSERT, ON-UPDATE and ON-DELETE triggers at the block level that perform the required actions against the view.

  3. #3
    Join Date
    Mar 2004
    Location
    london
    Posts
    10

    Thumbs up Re: FRM-40602: Cannot insert into or update data in a view

    I defined the on-update trigger at the block level and it works!
    thank you so much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •