Home » Developer & Programmer » Forms » frm-40501 (ora7i/Forms60)
icon8.gif  frm-40501 [message #417417] Sat, 08 August 2009 01:45 Go to next message
rosylips
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,
Rosy.

Report message to a moderator

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

David

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:27:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.