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)
>repl b with repl('Q', 200)
>? atc(test.b, test.a)
>repl b with repl('Q', 220)
>? atc(test.b, test.a)
>
>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)
>>>repl b with repl('Q', 200)
>>>? atc(temp.b, temp.a)
>>>repl b with repl('Q', 220)
>>>? atc(temp.b, temp.a)
>>>
>>>
>>>Cheers,
>>>
>>>Andrew
>>>
>>>>Steve,
>>>>
>>>[snip]
>>>>
>>>>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.