Home » Developer & Programmer » Forms » Update View (Form Bulider 6i)
Update View [message #322841] Mon, 26 May 2008 07:04 Go to next message
Messages: 1
Registered: May 2008
Junior Member
I have created a view like below and used in a data block.

create view po_view as
select ood.organization_code,pov.segment1,pov.vendor_name,pvs.vendor_site_code,tsh.vendor_id,
tsh.subinventory_code from org_organization_definitions ood, po_vendors pov,
po_vendor_sites_all pvs ,tab_smi_hubs tsh
pov.vendor_id = pvs.vendor_id
and pvs.vendor_site_id = tsh.vendor_site_id
and ood.organization_id = tsh.organization_id

The Find Block Displays the Column's as expected using WHEN_BUTTON_PRESSED Trigger.
But now I also need to update & delete from the View.

I've checked the Insert Allowed, update Allowed and Query Allowed properties on all items to Yes. I get a message
FRM -40602 : Cannot insert or update in a View.

From this Forum I got a Message saying "check view USER_UPDATABLE_COLUMNS and it will tell you whether your view supports update, insert, or delete". but i dont have such column on view. I’m not sure where i need to check

Thank for your help in advance.

Re: Update View [message #322912 is a reply to message #322841] Mon, 26 May 2008 18:20 Go to previous messageGo to next message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
You can't insert, update or delete the Complex views.
For this purpose you have to use INSTEAD OF trigger in database operations.

From Forms you can use ON-INSERT, ON-UPDATE and ON-DELETE triggers.

Have you tried them?

Re: Update View [message #322931 is a reply to message #322912] Mon, 26 May 2008 21:20 Go to previous messageGo to next message
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

search for materialized view, you can update it but it does not automatically refreshed
Re: Update View [message #331563 is a reply to message #322841] Fri, 04 July 2008 00:40 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If ALL the fields of ALL the primary keys are referenced in the view then it should work.

Previous Topic: list item
Next Topic: Disable the form
Goto Forum:

Current Time: Fri Aug 18 21:04:24 CDT 2017

Total time taken to generate the page: 0.17176 seconds