Home » Developer & Programmer » Forms » how can i know the time of a query ?
how can i know the time of a query ? [message #413966] Sun, 19 July 2009 18:16 Go to next message
titan_eye
Messages: 7
Registered: May 2009
Location: iraq
Junior Member

hi 2 all ,

i wanna know the time of a query ( elapsed time )

in SQL it is simply done by: set timing on

and in elapsed time: xx:xx:xx

but in forms i dont knnow how to do it ?
Re: how can i know the time of a query ? [message #413977 is a reply to message #413966] Sun, 19 July 2009 23:59 Go to previous messageGo to next message
blaxmi
Messages: 36
Registered: May 2008
Location: Hyderabad
Member
Hi,

Read the forms help topics. You may get solution for this problem.

bye
Re: how can i know the time of a query ? [message #414069 is a reply to message #413977] Mon, 20 July 2009 04:54 Go to previous messageGo to next message
titan_eye
Messages: 7
Registered: May 2009
Location: iraq
Junior Member

its not helping

any solution please ?
Re: how can i know the time of a query ? [message #414641 is a reply to message #414069] Thu, 23 July 2009 01:36 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In the 'pre-query' trigger record the time. In the 'post-query', get the time and calculate the difference. Remember that 'pre-query' fires once and 'post-query' fires for each record, so you will have to handle a flag so that you only do the calculation once.

David
Previous Topic: please help me.
Next Topic: Missing Status Bar
Goto Forum:
  


Current Time: Tue Dec 06 04:41:18 CST 2016

Total time taken to generate the page: 0.09678 seconds