General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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