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!

how to change block status

JIeHuHApr 20 2015 — edited Apr 20 2015

How to change block status of non database block with non database items from QUERY to CHANGED?

I cant change record property as

     SET_RECORD_PROPERTY(GET_BLOCK_PROPERTY(:SYSTEM.Cursor_Block, CURRENT_RECORD ), :SYSTEM.Cursor_Block,STATUS, CHANGED_STATUS);

because record status is "Inserted" and i get frm-40742 error.

This block can be committed by custom key-commit trigger. Logic of commit cant be linked to database tables.

So, I need in standard message as .. "Data was changed. Would you like to exit from form without saving? OK NO"

Oracle forms version - 6i

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2015
Added on Apr 20 2015
2 comments
7,936 views