Oracle Forms: How do I Update a Detail Updateable Query

[DCCoolBreeze]

I have two views similar to two tables. One is the main view and the
other is the detail view. I have placed them onto a canvas and they
do display to correct records relative to their keys. I can update
and delete records on the main view but I cannot update or delete
records on the detail view. Basically it returns the error FRM-40200
- field is protected against update. The update allowed property is
set to yes.

Any help?

[DA Morgan]

DCCoolBreeze wrote:

You will likely need an INSTEAD OF trigger due to the possibility of
updating the primary key in the underlying table.

If your views are similar to the tables why use the views?

Daniel Morgan

[DCCoolBreeze]

Unfortunately, I have to maintain the table structure. There are 4
tables; 2 sets of two identical tables with different names. Each two
tables are combined using a "union all" clause.

I have instead of triggers defined but that did not work.

DA Morgan <damo...@exesolutions.com> wrote in message news:<3E6F60CA...@exesolutions.com>...

[DA Morgan]

DCCoolBreeze wrote:

If your INSTEAD OF triggers didn't work ... my inclination would be to believe that the problem is with
your code rather than the trigger's functionality.

Why not restate the original problem, post the trigger and let us take a look.

Daniel Morgan

[URNinja-ed]

If your DDL view columns are based on a single table than it is
updateable in forms.
If your DDL view columns are based on more than one table, then
it isn't updateable.
The fact that the form does not allow you to even update the field
suggests you need to apply a patchset to your forms developer
suite. There was bug in forms 6i that prevented the user from updating
any view fields.

Regards
 

DCCoolBreeze wrote:

--
Suzuki SV650S - plop.  Gone.
Kwak ZX-6R J2 - hear the roar