update column from previous row's column in Form (Merged 3) [message #332368] |
Tue, 08 July 2008 06:20  |
khamkha
Messages: 22 Registered: May 2006
|
Junior Member |

|
|
Dear Members,
I'm in trouble during my form creation........
I have following fileds in the table and also making form on it for data entry:-
create table poluse
(V_REG_NO VARCHAR2(12),
START_DATE DATE,
START_TIME NUMBER(4),
MTR_START_RD NUMBER(12),
END_TIME NUMBER(4),
MTR_END_RD NUMBER(12),
FINAL_TIME NUMBER(4),
MPKM_USE NUMBER(12),
BRIEF VARCHAR2(100),
OFFICIAL_PVT VARCHAR2(12),
OFFICER_NAME VARCHAR2(25))
probulms:-
1. what type of data type for start_time and end_time fileds?
0730 am to 1030 am and auto difference save in total_time how?
2. USING FORM, When I enter data in MTR_END_RD field last reading then auto difference of start reading (MTR_START_RD)store in MPKM_USE killometer useing field. How its posible
3. USING FORM, When I enter data for the Second record or third or fourth record then previous record field MTR_END__RD end reading is automatically store in the filed MTR_START_RD as a start reading. I enter only end reading... and so on for new record entery on FORMs.... How i get old previous record filed data and store in the form?
PLEASE HELP ME WITH THANKS
WITH BEST REGARDS
Mr. Kiani
|
|
|
|
UPDATE COLUMN FROM PREVIOUS ROW'S COLUMN IN FORM [message #332464 is a reply to message #332368] |
Tue, 08 July 2008 10:48   |
khamkha
Messages: 22 Registered: May 2006
|
Junior Member |

|
|
I have some problem, may be not clearly define......I have data in the following format and create a table and update though same shape in FORM....
Enter SR-NO (1), DATE, START-TIME, START-READING, END-TIME & END-READING THEN TOTAL-TIME and TOTAL-READING must Automatically Calculate, and when enter SR-NO (2) ROW then enter SR-NO, DATE, and START-READING is automatically ENTER from previous ROW field/column END-READING because of START-READING is always same as the LAST RECORD/ROW END-READING.... HOW it is possible in FORM...... PLEASE HELP ME WITH THANKS.......
SR-NO DATE START-TIME START-READING END-TIME END-READING TOTAL-TIME TOTAL-READING
1 2-2-08 0830 100 1010 170 1H 40M 70
2 2-2-08 1030 170 1340 280 3H 10M 110
3 2-2-08 1400 280 1530 310 1H 30M 50
4 3-2-08 0830 310 1030 410 2H 100
5 3-2-08 1230 410 1530 620 3H 210
BEST REGARDS
KHAMKHA (KIANI)
[Mod-Edit: Frank added code-tags and changed topic title]
-
Attachment: POL.JPG
(Size: 38.04KB, Downloaded 498 times)
[Updated on: Tue, 08 July 2008 15:03] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|