Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Building a complex query
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00980679
Message ID:
00981290
Views:
78
You have no trouble because I suppose You always replace the field with ALLTRIM() of some value. I e there is no trailing blanks in the field so the index is with fixed length no metter that there is TRIM() in it. But If You replace Comany field with values that have trailing blanks then o are in trouble :o))). VFP till 9 doesn't manage such indexes well and You an get some error.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform