I have a view based on two tables joined by the id of a parent table with the same id as a foreign key in the child table. This is the select statement for my view.
Code:
SELECT L.AGENT_NUM, L.SCAC, L.LOI_DATE, L.LOI_REPL_DATE, F.AREA, L.LOI_CANCEL_DATE,
L.BOOKING_AGENT, L.GBLOC
FROM LOI_AUTHORITY L, FP_AREAS F
WHERE L.FP_AREA_ID = F.ID
This is the select on data dictionary to see what rows of views have update, insert and deletes.
Code:
1 SELECT column_name, updatable, insertable, deletable
2 FROM user_updatable_columns
3* WHERE table_name = 'LOI_FP_AREAS_VIEW'
oracle@CVLPL> /
COLUMN_NAME UPD INS DEL
------------------------------ --- --- ---
AGENT_NUM YES YES YES
SCAC YES YES YES
LOI_DATE YES YES YES
LOI_REPL_DATE YES YES YES
AREA NO NO NO
LOI_CANCEL_DATE YES YES YES
BOOKING_AGENT YES YES YES
GBLOC YES YES YES
8 rows selected.
My question is when I use the view in my Oracle Forms 6i and try to do an update it does not allow me. I'm using Oracle 8i on windows NT. Does anyone has any clue as to what I am missing? Thanks.