Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Undocumented feature of Indexing
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Undocumented feature of Indexing
Miscellaneous
Thread ID:
00343211
Message ID:
00343211
Views:
54
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?
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Next
Reply
Map
View

Click here to load this message in the networking platform