Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FILTER Condition
Message
 
 
To
02/09/2008 16:24:22
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01344062
Message ID:
01344524
Views:
15
>>THISFORM.FilterCondition = THISFORM.FilterCondition +
>>' AND BETWEEN(TransDt,{' + TRANSFORM(THISFORM.TransDtBegin) + '},{' + TRANSFORM(THISFORM.TransDtEnd) + '})'
>>m.FilterCondition = THISFORM.FilterCondition
>
>It will work if SET STRICTDATE TO 0
>If SET STRICTDATE TO 1 or 2 it fails
>
>More precise expression, independendent of this setting
>THISFORM.FilterCondition = THISFORM.FilterCondition + ;
>' AND BETWEEN(TransDt,{^' + TTOC(THISFORM.TransDtBegin,3) + '},{^' + TTOC(THISFORM.TransDtEnd,3) + '})'

Yes, I used some UDF for this, but I guess TTOC ,3 will work.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform