daogu

hi friends

i am asked to show the time taken to commit a form after the save button is preseed in the form. Please help me how to do it ?

Looking forward for reply…thanks in advance..

---

Answer:Very simple my friend…

v_start_time := sysdate;

commit;

v_end_time := sysdate;

commit_time := v_end_time – v_start_time

I hope you got my idea…

Regards,

Azam Khan

---

Answer:first of all thank u for ur kind reply.

i have created a form

with three fields. first two fields with datatype ‘DateTime’ with formatmask ‘DD/MM/RRRR HH:MI:SS’ and the third field with datatype ‘Number’ . there r three buttons also. when the first button presseed it will select the sysdate into the first textitem and when the second button pressed it also select the sysdate into the second text item. so when the third button pressed it will find the difference of the first two text items and assign it to the third text item.

let the first text item value be ‘08/01/2008 11:33:46′

and the second text item value be ‘08/01/2008 11:33:52′

and when the third button pressed the third textitem shows the defference as ‘.00006944444444444444444444444′ wht this third value really shows.is it in milliseconds..plz explain wht this third value really represents..

---

Answer:It is number of DAYS. From your example, it is obvious that the difference is 6 seconds. Here’s how it is calculated:

Related posts:

1. how a user do not put date greater than today in date field In my form there is a date field and...
2. Text IO file reading Hi, I have an exe that reads a value...
3. date display through global varibales I have set the datatype of date textitem to...
4. Show a tab Page Hi, I have a canvas that have four tab...
5. To poulate a text item from LOV I created a form it contains 2 text items...