disableing an item in enter query mode

In your KEY-ENTQRY write the below code: this is tested on Forms 10g
If you need to disable querying of an item under a certain condition, include that condition in the trigger too

IF ... THEN
  SET_ITEM_PROPERTY('ENAME', QUERYABLE, PROPERTY_FALSE);
END IF;
ENTER_QUERY;

This will prevent the user from entering any text in the item when the KEY-ENTQRY trigger is fired. Remember to set it back to true when you cancel the query or when the query is executed.

Tony

I get the impression you're not reading the replies fully. For example, I said what trigger to put that code in, just above the code snippet, and you've not responded to numerous suggestions that you use the Query Allowed property of the item. Setting that property would be the best way to implement this functionality unless you need the item to be queryable under certain conditions.

The code I posted above will not work, please accept my apologies. The Enabled property has no effect in enter-query mode. However, this code has been tried and tested:

if <condition> then
  set_item_property(<item>, queryable, property_true);
else
  set_item_property(<item>, queryable, property_fase);
end if;

enter_query;

The code should go in the key-entqry trigger.

you're welcome.

PS: If your question has been answered, please mark the question as answered, so it helps other people when they search the forums.

Edited by: Tony Garabedian on Aug 29, 2008 2:29 PM