| how can i know the time of a query ? [message #413966] |
Sun, 19 July 2009 18:16  |
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 #414641 is a reply to message #414069] |
Thu, 23 July 2009 01:36  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
