This content has been marked as final. Show 5 replies
its not clear what u r trying to do...
But if u r building a time attendance application then u have to set up the shifts or periodic time table in order to validate their actual attendance time towards the rules of work attwndance u have to set up.
Recommended a date data type which includes both time & date internally.
U will also need time in & out hence date of attendace.
This is my proposal for what u explained.
Good Luck :)
It is always a good idea to provide your Forms Version! If you are using Forms 6i (6.0.8.x.x) or higher then you can set the Data Type property of your item to "Datetime". I don't have access to Forms 5 and earlier and I don't remember if these versions supported the "Datetime" data type, so you are using Forms 5 or earlier, you will have to use a standard Date data type and then set the format mask to restrict input to an acceptable time format (eg: HH24":"MI).
... I must make a control for this item in " when-validate-item trigger" .I don't understand why you need code to validate the time entry when a Format Mask on the item will ensure only valid time's are entered. Do you need to check if the time is between a threshold or some other check not related to "is the time entered a valid time"? You can do this kind of checks in your When-Validate-Item (WVI) trigger using standard PL/SQL logic (>, <, <>, etc) as well as standard Date Functions.
Can you be more specific on what you need to perform in your WVI trigger?