Home » Developer & Programmer » Forms » frm-40501 (ora7i/Forms60)
icon8.gif  frm-40501 [message #417417] Sat, 08 August 2009 01:45 Go to next message
Messages: 1
Registered: August 2009
Junior Member
Hi All,
In my Forms, I have an INSTEAD OF trigger on my views. There are 5 different data blocks. All is fine except for the last block. When I try to UPDATE this block it displays "FRM-40602:Cannot insert into or update data in a view.". When the same is performed on other data blocks it works absolutely fine. All the fields in the property palette are identical for each of the blocks, except for names.
Please help me in this regard.

Thanks in advance,
Re: frm-40501 [message #417492 is a reply to message #417417] Sun, 09 August 2009 20:13 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'update view'. You need to review the contents of 'all_updatable_columns'.

Previous Topic: forms 10g is slower than forms 6i
Next Topic: Unable to connect with database from Form Builder
Goto Forum:

Current Time: Thu Oct 20 16:52:23 CDT 2016

Total time taken to generate the page: 0.10427 seconds