Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Undocumented feature of Indexing
Message
From
09/03/2000 00:30:14
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00343211
Message ID:
00343575
Views:
14
All in all, it doesn't really work! :) The real problem (bug, IMHO) is that VFP accepts indexes on variable length
char expressions. And regardless of any advice you may get from anybody in favor of such indexes, I can't advice
against enough. The problems generated by such indexes are subtle and, usually, hard to find and hard to fix.

Vlad

>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform