Steve,
>>Tom,
>>
>>The limitation is actually 255 characters. If you make a to equal 255 characters the function works. At 256 it fails.
>>
>>However, if you make the characters different like this:
>>
>>a=REPLICATE("X",100) + REPLICATE("Y",100)+REPLICATE("Z",100)+REPLICATE("Q",100)
>>
>>?ATC("Q",a)
>>
>>Then the ATC command correctly returns 301.
>>
>>Apparently there is a limitation
if the characters are all the same. I'd guess that internalls VFP parses the string to separate 255 length 'sub' stings.
>>
>>
>Hey Doug,
>
>From the docs:
>
>
>Both cSearchExpression and cExpressionSearched can be memo fields of any size.
>
>
>It does appear to be a bug...I guess not that many people have had to do case insensitive searches for long strings for it to live this long.
It works for
memo fields but the example given was a
string, not a memo field. Check it out.
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.
