Hi Doug,

Nope, but you might in a 400 character string (200 + 200) - I built it that way (200xQ + 200xA + 200xQ + 200xQ) to eliminate any potential for bogus buffering from the replicate process - no real science. It could have just have easily been 200Q + 200A + 400Q (Note also I got a 401 from the third test I think 220 > 200, but I have just been doing maths with my 4 year old so I could have things a little jumbled <g>).

Cheers,

Andrew

>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.