Create a form on join tables/view

2778983

Hi, I think I posted this in the wrong place before.

Anyway I have this issue, I need to create a form that inserts on to more than one table, i have created this view:

CREATE OR REPLACE VIEW AS

  SELECT o.order_id, i.order_item_id, c.customer_id, c.customer_fullname, p.product_id, p.product_name, NVL(i.quantity, 1) as quantity, p.product_price, (NVL(i.quantity, 1)*i.unit_price) as "Sub Total", o.total

FROM customers c

JOIN orders o

ON o.customer_id = c.customer_id

JOIN ORDER_ITEMS i

ON o.order_id = i.order_id

JOIN products p

ON i.product_id = p.product_id;

I have used automatic row fetching and automatic row processing

The page has only customer fullname, product name and quantity visible, i have hidden the rest. When i run the page, enter data (which are a list of LOVs) and click create I get this error: ORA-01779: cannot modify a column which maps to a non key-preserved table.

Could someone please assist me with this thank you

TexasApexDeveloper

You will need to look at adding an Instead of Trigger to your view to handle the insert/updates properly.. : Instead of Triggers on Views Example in Oracle

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

2778983

Thanks, I will try this

2778983

Hi, So I tried creating an instead of trigger and I got this error in SQL workshop:

Error at line 15: PL/SQL: SQL Statement ignored

1. CREATE OR REPLACE TRIGGER insert_orders_view_01

2. INSTEAD OF INSERT ON ORDERS_VIEW_01

3. DECLARE