1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Updatable View Based form

Discussion in 'Oracle Forms and Reports' started by ashok.ambure, Dec 1, 2011.

  1. ashok.ambure

    ashok.ambure Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi all

    My Requirement...
    1) I have made a custom form but it is based on table based but my requirement to change to updatable view based form...

    please help...
     
  2. nep84

    nep84 Active Member

    Messages:
    4
    Likes Received:
    3
    Trophy Points:
    85
    Location:
    NJ
    if the view can still find a rowid then you can still use it as a base table in the form and update it directly. if the view has a join or a grouping or anything else that loses rowid then you must change the dml target on the block to procedures, write your own apis, and on-insert, on-update, on-delete, and on-lock triggers.
     
    Sadik likes this.