discusmania
IS-IT--Management
Hello....
for example I have 2 tables in my oracle database. The first 1 is defects and the 2nd is sm_tracks. to calculate defect per kilo unit (DPKU)=defects(from defect table)/sm_tracks(from sm_tracks table). the DPKU then will be displayed to the user on the screen in html table format.Then there is a capture button there. when the user press the capture button, the displayed data will be directly store to another table which is called prolist, in db.
The problem is i want to capture the DPKU which is listed in the html table on the screen without have to perform the calculation again, and without invovle any of the 2 db tables mentioned above.It is because the process is not only calculate the DPKU but many other else.
the question, is it possible for me to directly capture the information in html table format?
please help
Thank You
NOR
for example I have 2 tables in my oracle database. The first 1 is defects and the 2nd is sm_tracks. to calculate defect per kilo unit (DPKU)=defects(from defect table)/sm_tracks(from sm_tracks table). the DPKU then will be displayed to the user on the screen in html table format.Then there is a capture button there. when the user press the capture button, the displayed data will be directly store to another table which is called prolist, in db.
The problem is i want to capture the DPKU which is listed in the html table on the screen without have to perform the calculation again, and without invovle any of the 2 db tables mentioned above.It is because the process is not only calculate the DPKU but many other else.
the question, is it possible for me to directly capture the information in html table format?
please help
Thank You
NOR