call or display data which has been save. how? [message #86053] |
Wed, 25 August 2004 19:34 |
Dhalan
Messages: 15 Registered: August 2004
|
Junior Member |
|
|
HAI,
create table test (
icno varchar2(10),start_am varchar2(10), end_am varchar2(10)
for example in FORM BUILDER, i insert some data and then save it and then clear the form by implement some coding such as DO_KEY('clear_form')
B4 save
icno start_am
----------------------------------------------------------------------
after save
icno start_am
<OL>
[*]00-123456 07:45:50 --on monday
[*]00-987456 07:30:00 --on monday
[*]00-123456 07:50:12 --on tuesday
[*]00-987456 07:45:50 --on tuesday</OL>
i know, after i press the button it will clear all the information on the form but its ok because i already save it. im doing so because not only one user use it. different user can have different time( e.g. come to work)
my question is, how can i retrieved or call the data(07:50:12) and display it at start_am once again if user 00-123456 enter his ic. by doing so, thats mean the start_am is not null and i can display new time at start_pm automatically.
sorry if you do not understand my example :(
anyway thanks for your help
regards
eboy
|
|
|