Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing memo fields
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01320108
Message ID:
01320178
Views:
17
>Ok, how do we index memo fields? It used to be that there was a product that did this back in the day. PhdIndex or something like that. Haven't needed it so much, but I do have one place where it'd be nice now.

PhdIndex was for full text search and reported to be buggy. As Bill said, the "normal" use would be to index on a vfp expression, mostly left / padr. Actually you can use ANY vfp UDF (as long as you make certain a fixed length is returned), but in vfp9Sp1 such indexes are not used by rushmore due to a bug I discovered, unless you additionally force parameters to be value type:
myMemoUdfforCdx((tcStr)).

Seek() works without the second pair of (), but I was very happy to be able to use my UDF's in SQL-Select.

HTH

thomas
Previous
Reply
Map
View

Click here to load this message in the networking platform