Sorry, my typo, I should have cut and pasted. Really it is this :
lx = "Zip Code"
ly = "Zip"
at(ly,lx)
returns 0 instead of 1
INSERT INTO test1 (test1) VALUES ("My US based Zip Code")
AT("Zip",(test1.test1)
returns 0 instead of 16.
Thanks,
>>
>>
>>I asked about this once before a while back, and nobody seemed to have heard about, but I was too busy to check it out.
>>
>>The AT() command frequently and consistantly returns 0 when it should not.
>>
>>lx = "Zip Code"
>>ly = "Zip"
>>at(lx,ly) returns 0 instead of 1
>>
>>or
>>
>>INSERT INTO test1 (test1) VALUES ("My US based Zip Code")
>>AT(test1.test1,"Zip") returns 0 instead of 16.
>>
>>
>>Anyone?
>
>You have the parameters in the wrong order. Your first example should be:
>
>...
>? at(ly, lx)
>...