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.