on 7/29/01 21:31, Aaron Bratcher at aaronbratcher at mac DOT com wrote:
> If a FieldMethod is changed after it has been indexed, then any
> search on this field will not work properly because it is searching
> the index that is based on the old Method contents..
>
> I have a distance field which I set to:
> 3963.0 * acos(sin(0.586994)*sin(lat) +
> cos(0.586994)*cos(lat)*cos(lon--1.95673))
> (Yes, this function is correct)
>
> With this function in place, I can now do a SQL query:
> select ** from zips where distance < 25
>
>
> Now if I change this function to:
> 3963.0 * acos(sin(0.59651)*sin(lat) +
> cos(0.59651)*cos(lat)*cos(lon--2.067049))
>
> and run the same sqlSelect
> select ** from zips where distance < 25
>
> it returns the same records that were returned above... but the
> distance "field" shows that all the distance are much greater than 25
> miles.
Hi Aaron,
what version ? 1.8.8r5 ?
this was fixed in later betas of 1.8.9
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on at lists DOT macserve.net
©2001 Ruslan Zasukhin |
