>Hi all
>
>I want to have an index tag on a field of 254 characters but the limit for a tag is 240 characters only. What is the work around?
>
>I heard of some external library that can be plugged into the VFP for this. Can anyone provide me some info on this?
>
>Thanks in advance.
>
>Vikas
Vikas,
240 limit is for collation sequence set to machine and null support is OFF for the indexed field. If collation sequence is something else than half the limit and subtract one if null support is ON for the indexed field (thus limit might be 120,119,239 or 240 for your case).
Instead of a plain :
index myField tag myField
expression you might index on another expression that'd compress the size. ie:
index on sys(2007,myField) tag myField
would yield an index key of 5 bytes at max. Your searches OTOH would need to be exact matches since with checksum even a bit change matters.
Cetin