first disable the check box by using
then when u want to enable that use as shown below
set_item_property('BLOCK.ITEM',update_allowed,property_true);
Bency J Mathew
s/w engineer
TRASSET INDIA
This blog provides many tips and tricks for oracle forms developers.It focusing on exploring new things in oracle forms. Many of the things given in the blog is not available in other sources.
The idea for this blog took shape from the many requirements and doubts that I came across during the initial stage of my programming career. The intention of creating this blog was to provide a better understanding of the concepts of Oracle forms,reports and PL/SQL. I am sure that this blog will be useful for those who want to develop some basic programs on Oracle and also those who like to explore more on it.
I'm new to Oracle Forms 10g.
ReplyDeleteWhen I create a data block based on a table using Data Block Wizard, the block's Query Data Source Columns property is automatically populated with column definition entries corresponding to the columns of the base table.
I tried making changes to these entries, for example by changing the data types to wrong data types or even deleting them, and I found that those changes had no effect on the block at all. The form was still working as I wanted.
Please explain what is exactly the role of the block's Query Data Source Columns property.
Thank you very much.
p.s: The F1 key help says "The Query Data Source Columns property is valid only when the Query Data Source Type property is set to Table, Sub-query, or Procedure". So, please explain in each context of Query Data Source Type.