>Hi All,
>I didn't know this and while I'm sure everyone else did *s*, I'm going to post it anyway.
>
>VFP throws an error when you attempt to index on a memo field. Error 34 - Operation is invalid for a Memo, General, or Picture field. But if you wrap the memo field in a text manipulation function (e.g. alltrim(), upper()), it allows it.
>
>Someone posted some code about indexing on a memo field and I sent back saying you can't do that. They sent back saying I already do this, here it is and why does it work.
>
>Any ideas?
Yup, I've done this too. The reason is that you can't index on a memo expression, but you can index a simple character expression (which can be any length). Look what happens with the TYPE() of the field here:
?TYPE("MyMemoField")
?TYPE("ALLTRIM(MyMemoField)")
Erik Moore
Clientelligence