Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Undocumented feature of Indexing
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00343211
Message ID:
00343219
Views:
21
>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?

Interesting, but what does this do the the size of the CDX? It must be a monster.
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Previous
Reply
Map
View

Click here to load this message in the networking platform