| Update View [message #322841] |
Mon, 26 May 2008 07:04  |
smitha_priya
Messages: 1
Registered: May 2008
|
Junior Member |
|
|
Hi,
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
where
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.
Thanks,
Priya
|
|
|
|
|
|
|
|
| Re: Update View [message #331563 is a reply to message #322841] |
Fri, 04 July 2008 00:40  |
 |
djmartin
Messages: 10181
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.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
