1st question: what is the item must be of type integer or number or ... ?The itemtype could be a NUMBER.
2nd question: I created a trigger when-validate-item whose code is:No need for any trigger. In the properties you can set the minimum value and the maximum value.
i think i will use trigger because when user enter wrong date ,so the code will be like this:Seems that you like it complicated..
979155 wrote:Yes , you can display message in alert box.
I know that dera error message displayed at the box ...
but is there a possibility to display this message in a alert message ??
Hope this helps..
DECLARE ALT NUMBER; BEGIN IF <your condition> THEN ALT:=SHOW_ALERT('alert_name'); END IF; END;