disableing an item in enter query mode

If you want to prevent a user entering data in a feld when they do a query, set the item's Query Allowed property for No.

Otherwise, the trigger you're looking for is key-entqry.

what do you mean by it's not working??? are you getting an error???
Like I said in my previous post, you can set the item's property false for "Query Allowed" this will not allow the user to use this item as a query item.


Tony

Edited by: Tony Garabedian on Aug 28, 2008 5:44 PM

You can't set the enabled property if the cursor is in the item and I expect it's the same for the query_allowed property. if the cursor is in the item which you set to Query_Allowed=false and then you go to enter-query mode, perhaps forms doesn't know what item to move the cursor to, so just leaves it where it is.

You can solve the problem by moving to a different item (with go_item) before setting the property.

When do you need to set the item back to enabled? If you want it enabled at all times other than when a query is being entered then use the Property Pallet to set the Query Allowed property. If you want to disable the field under certain conditions then the when-new-record-instance trigger might be better for you. Eg

if :system.mode = 'ENTER-QUERY' and <condition> then
  go_item(<another item>);
  set_item_property(<item>, enabled, property_false);
else
  set_item_property(<item>, enabled, property_true);
  set_item_property(<item>, update_allowed, property_true);
  set_item_property(<item>, navigable, property_true);
  set_item_property(<item>, update_null, property_true);
end if;

It might be better to set the query_allowed property instead of the enabled property, but I can't check right now whether that's possible after the enter-query mode has begun.

The update_allowed, update_null and navigable properties are all set to false as a consequence of the enabled property being set to false. If they should be true then you need to reset them after reenabling the item.