Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox and Filter
Message
 
To
23/12/2004 07:40:11
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00971725
Message ID:
00971753
Views:
17
When You use a macro to set the filter it reproduce following:
lcFilter = [country = '] + ALLTRIM( this.Value  ) + [']
SET FILTER TO &lcFilter
** It means
SET FILTER TO Country = 'SomeCountryName' && Then Country must be Character, This.Value must be Character too


*******************************
lcFilter = [country = ] + TRANSFORM(this.Value) && w/o [']
SET FILTER TO &lcFilter
** It means
SET FILTER TO Country = 5 && Then Country must be Numeric, then This.Value must be numeric too
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform