How to disable a block on form intiation and to enable the same on button click in oracle forms

properties triggers oracle10g oracleforms
lakshganga picture lakshganga · Dec 6, 2013 · Viewed 16.8k times · Source

I am new to oracle forms. I want to disable a data block on form initiation and to enable the same on button click.

I wrote 2 triggers

1. "when_new_form_instance"
SET_BLOCK_PROPERTY('ADD_STUDENT',enable,PROPERTY_FALSE);
2."when_button_pressed"
SET_BLOCK_PROPERTY('ADD_STUDENT',enable,PROPERTY_TRUE);
Its throwing some error that "no such property for SET_BLOCK_PROPERTY"



Help would be much appreciated!

Answer

nightfox79 picture nightfox79 · Dec 7, 2013

You can't disable a block. You have 2 options:

  1. If it is on a tabpage put the enable, of visible property of the tabpage to false.
  2. Put the following propertys to false: insert_allowed, update_allowed, delete_allowed, query_allowed. After that you can't do anything in the block.

Related questions

In XAML, how can I keep an ellipse being a circle?

I'm getting XAML-blind I'm afraid. I'm developing a MS Surface application and I have an ellipse inside a ScatterViewItem (a container an end user can resize). I would like to keep the ellipse a circle (width == height) and keep it …

Read More
What is the { get; set; } syntax in C#?

I am learning ASP.NET MVC and I can read English documents, but I don't really understand what is happening in this code: public class Genre { public string Name { get; set; } } What does this mean: { get; set; }?

Read More
Sorting object property by values

If I have a JavaScript object such as: var list = { "you": 100, "me": 75, "foo": 116, "bar": 15 }; Is there a way to sort the properties based on value? So that I end up with list = { "bar": 15, "me": 75, "you": 100, "foo": 116 };

Read More