Andrew,

Try making 'b', in your first test that returns 0 to be a length less than 200. I haven't checked this yet myself but I'd think that you wouldn't find a 300 character string anywhere within a 200 character string. <g>

Make sense?


>Hi Doug,
>
>After I fix up the temp/test mixup <g> I get 0, 1, 401:
>

CREATE TABLE c:\temp\test (a m, b m)
>a = repl('Q', 200) + repl('A', 200) + repl('Q', 200) + repl('Q', 200)
>b = repl('Q', 300)
>insert into test values (m.a, m.b)
>? atc(test.b, test.a) && returns 0 - Buh-Bough (Family Fued reference)
>repl b with repl('Q', 200)
>? atc(test.b, test.a) && returns 1 - correct
>repl b with repl('Q', 220)
>? atc(test.b, test.a) && returns 401 - correct

>
>Cheers,
>
>Andrew
>
>>Andrew,
>>
>>Interesting..
>>
>>Here it gets even weirder. Try this:
>>
>>
>>* create cursor temp(a M, b M)
>>CREATE TABLE test (a m, b m)
>>
>>a = repl('Q', 200) + repl('A', 200) + repl('Q', 200) + repl('Q', 200)
>>b = repl('Q', 300)
>>insert into temp values (m.a, m.b)
>>? atc(temp.b, temp.a) && returns 0 - Buh-Bough (Family Fued reference)
>>repl b with repl('Q', 200)
>>? atc(temp.b, temp.a) && returns 1 - correct
>>repl b with repl('Q', 220)
>>? atc(temp.b, temp.a) && returns 401 - correct
>>
>>Let me know what you get. I get three zeros........
>>
>>
>>
>>>Hi Doug,
>>>
>>>Looks to me like it breaks for memo fields too:
>>>

>>>create cursor temp(a M, b M)
>>>a = repl('Q', 200) + repl('A', 200) + repl('Q', 200) + repl('Q', 200)
>>>b = repl('Q', 300)
>>>insert into temp values (m.a, m.b)
>>>? atc(temp.b, temp.a) && returns 0 - Buh-Bough (Family Fued reference)
>>>repl b with repl('Q', 200)
>>>? atc(temp.b, temp.a) && returns 1 - correct
>>>repl b with repl('Q', 220)
>>>? atc(temp.b, temp.a) && returns 401 - correct
>>>

>>>
>>>Cheers,
>>>
>>>Andrew
>>>
>>>>Steve,
>>>>
>>>[snip]
>>>>
>>>>It works for memo fields but the example given was a string, not a memo field. Check it out.