Skip to Main Content
Forums

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 protect the field against update

Srikkanth.MJan 9 2012 — edited Jan 9 2012
Hi All,

I am using oracle forms 10g,

I have created a form and the form has 15 fields,So out of 15 fields i need to only 5 fields need to get updated by the user. All the fields need to be protected against update.

I have set the Update allowed to 'NO' in the property palette and i have tried

Set_item_property('BLK.Field_name',Update_allowed,Property_false); for those item in pre_block trigger and also tried in when_new_block but it doesnt works, Can any tell me how to do this.

And one more question How to bring the cursor to the first record, When i enter a value and press button the field is queried and new block opens with data, but the cursor is in the last line that is empty line, So it need to be in the first line.I have tried FIRST_RECORD but it dosnt works.

Can any tell me how to do this please.

Thanks & Regards
Srikkanth
This post has been answered by 850050 on Jan 9 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2012
Added on Jan 9 2012
#forms, #moved-from-devops
7 comments
3,723 views