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.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.