main logo
Subject: Re: sql in a multi user lan vfp6sp5
Author: Ed Leafe
Posted: 2003/08/30 15:30:00
 
View Entire Thread
New Search


On Saturday, August 30, 2003, at 02:42 PM, Cindy Winegarden wrote:

> 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')

Or, better yet (at least as far as STRICTDATE compliance is concerned)

ldDate = DATE(2003, 1, 6)

This will be clearer to our European friends that we mean Jan 6, not
June 1.


___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://opentech.leafe.com






 
©2003 Ed Leafe
<-- Prior Message New Search Next Message -->