| Need Help Pls take A look? [message #85975] |
Wed, 18 August 2004 16:47  |
samsul
Messages: 4
Registered: August 2004
|
Junior Member |
|
|
hai
i have 4 field in my form such as start_am, end_am, start_pm and end_pm.
if user enter his Identity card no, the time will automatically enter to start_am.
my questions is, i want if the user enter his IC NO once again, the time will enter directly into end_am and the user cannot modify the time in start_am but he can see the time in start_am
can you teach me the command or give example so that i can understand
thank you for your kindness n may god bless you n your family
|
|
|
|
| Re: Need Help Pls take A look? [message #85978 is a reply to message #85975] |
Wed, 18 August 2004 20:01  |
AB
Messages: 41
Registered: July 2002
|
Member |
|
|
Hi,
Write the following block of code in When-Validate-Item trigger of ICNo field.
IF :Block_Name.Start_am IS NULL THEN
:Block_Name.Start_am := SYSDATE;
ELSE
:Block_Name.End_am := SYSDATE;
SET_ITEM_PROPERTY('Block_Name.Start_am',UPDATE_ALLOWED,PROPERTY_FALSE);
SET_ITEM_PROPERTY('Block_Name.Start_am',INSERT_ALLOWED,PROPERTY_FALSE);
END IF;
Regards
AB
|
|
|
|
| Re: Need Help Pls take A look? [message #85985 is a reply to message #85978] |
Thu, 19 August 2004 00:24 |
samsul
Messages: 4
Registered: August 2004
|
Junior Member |
|
|
ic no start_am end_am
00-288572 14:08:16
00-288573 15:08:45
select to_char(sysdate, 'hh24:mm:ss') into :test.start_am ---> i use this statement for time at start_am
hai,
for example, after user 1 enter his ic no 00-288572 the time will automatically put at start_am and then he save it. after that 2nd user enter his ic no 00-288573 and it also generate automatically as u can see from above example.
for example if user 1 want to go out for lunch he must enter his ICNO once again.
my question is, if user 1 enter his ICNO once again, i want to display the Start_am(14:08:16) and the new time at end_am so that i can calculate the difference between start_am and end_am
thanks for your reply AB
may god bless you for your kindness
|
|
|
|
| Re: Need Help Pls take A look? [message #86022 is a reply to message #85975] |
Sun, 22 August 2004 23:26 |
Rana Irfan
Messages: 15
Registered: August 2004
|
Junior Member |
|
|
Dear
U Insert the Time or Date in Required fields and then enabled the Field which required.with
Set_Item_Property('ItemName',Enabled,Property_False');
So user see the Field and Can't any Changes.
Regards,
Rana Irfan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
