Thankx Cindy
I am sure it will run faster. Its more like a Sql Tip.
Bobby
----- Original Message -----
From: "Cindy Winegarden" <cindy.winegarden .at. mvps .DO.T org>
To: <profoxtech@leafe.com>
Sent: Sunday, August 31, 2003 12:12 AM
Subject: RE: sql in a multi user lan vfp6sp5
Try code like this to eliminate the date conversion each time. My code ran
at least 30% faster when I was comparing to a date instead of CTOD().
LOCAL ldDate
ldDate = CTOD('01/06/2003')
SELECT ......
WHERE ... PatHead.PDate = ldDate ....
©2003 Bobby Khaund |
