I would suggest adding a temporary column into database, use the
distance(x1,y1,x2,y2) formula to fill the column and perform a query of
table using a descending sort on the temporary column. This will show the
entire list by distance.
Ken Fioretti wrote:
> Hello All,
> What is the simplest way to locate the nearest point(s) from a table of
> multiple points to another point. For example, I have a table of store
> locations and the point of a single address. How do I determine which
> are the nearest 3 stores in the store table to the address point? Do I
> need to write a MapBasic routine, or is there a native MI
> function/command?
> Thanks
> Ken Fioretti
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
