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 ....
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden .AT. mvps D.OT org
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces .AT. leafe D.OT com] On Behalf
Of Bobby Khaund
Sent: Friday, August 29, 2003 1:50 PM
To: profox@leafe.com
Subject: Re: sql in a multi user lan vfp6sp5
...
WHERE .... pathead.pdate = ctod('01/06/2003');
©2003 Cindy Winegarden |
