>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only