| how to retrieve the records that is save and display it? [message #86035] |
Mon, 23 August 2004 21:12 |
Dhalan
Messages: 15
Registered: August 2004
|
Junior Member |
|
|
begin
SELECT icno INTO :test.icno FROM PEKERJA WHERE ICNO = :test.ICNO;
IF :test.start_am IS NULL THEN
select to_char(sysdate, 'hh24:mm:ss') into :test.start_am
from sys.dual;
SET_ITEM_PROPERTY('test.Start_am',INSERT_ALLOWED,PROPERTY_FALSE);
else
*continue below
hai
icno start_am end_am
00-123456 15:30:00
<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">00-123455 15:30:00
<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">00-123466 15:30:00
<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">00-123477 15:30:00
<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">the information is save after they press save button.
my question is, if user 00-123456 enter his icno once again, how to read the record that is save and display the time(15:35:00) into start_am.
after display the 15:35:00 it is easy for me to put this statement
*continue from above
<SPAN style="FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">select to_char(sysdate, 'hh24:mm:ss') into :test.end_am
from sys.dual;
SET_ITEM_PROPERTY('test.Start_am',INSERT_ALLOWED,PROPERTY_FALSE);
END IF;
end;
can anyone modify the above or teach me how by giving example like i did so that it is easier for me to understand what u teach. thank you very much for ur concern
regard
eboy
thanks for helping me to solve my problems
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
