Skip to Main Content

Oracle Forms

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!

Updating a text field in aform based on conditions

951614Apr 1 2013 — edited Apr 3 2013
Hi ,

We are developing a custom form which has a database datablocks.
This form is a master detail form . It has a field called "status" whose initial values is 'Draft' and this field is present in the master part of the form.

The Logic for "Draft" is written in Pre-Insert trigger of the header block.

---------------------
Question
---------------------

If condition "A" is met and "B" is met , status should be set as a value called as 'Submitted';

If condition a is not met and B is met , status should be set as a value called as 'Created';

We are doing this in the post-update trigger at block level. But the changes are not taking effect.
Please let us know if this is the correct approach to handle the column. Note that the column "Status" is a database column.


Thanks and Regards
SR
This post has been answered by HamidHelal on Apr 3 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2013
Added on Apr 1 2013
18 comments
777 views