Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Edit Automatic Row Processing (DML)?

Leon_MApr 3 2015 — edited Apr 7 2015

Hello,

I am on Apex4.2

I have created a Form on a Table with Report and a Form is using Automatic Row Processing (DML) to Add/Edit/Delete.

I specified "Existing trigger" as a source of a Primary Key column.

How can I change it to "Existing sequence" instead? Is it possible at all?


The other question is how to add an item to be processed by Automatic Row Processing?

I added a column to underlying table and corresponding page item. I need to write this item's default value to the database.

I added column's name into the page item's Source definition. And it is even set to "Always, replacing any value.."

The item should be "Display only" thouh. If Item's value is null, then the default value should be written into the db.

It does not work this way for some reason. What is it that I'm doing wrong?


Thank you.

This post has been answered by Kiran Pawar on Apr 4 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2015
Added on Apr 3 2015
3 comments
604 views