Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date Filter on Form doesn't work properly
Message
From
23/04/2010 10:31:07
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01461572
Message ID:
01461717
Views:
102
Hi Hugo

Wouldn't execscript be heavy overkill?

I just had a thought triggered by your quote of premature optimization being the root of evil in programming.

If I use drywall and two-by-fours to build a house instead of toothpicks, I have chosen to optimize the construction process before the house is built rather than having built it with toothpicks and then throwing it all away. If I chose techniques that result in quickly built, reliable code, that is also fast, then IMO the evil is in not building optimal code in the first place, no?

>You can do something along this lines:
>
>
>	cFrom	= '{^' + cFromYear + "/" + cFromMonth + "/" + cFromDate + '}'
>	cThru	= '{^' + cThruYear + "/" + cThruMonth + "/" + cThruDate + '}'
>
>	cFilter	= [SET FILTER TO BETWEEN(Quotes.dQuote, &cFrom, &cThru)]
>	ExecScript(cFilter) && or &cFilter
>
>
>Hugo
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform