Thanks Curt.
I understand how the distance function would work. What if your 'store'
table has thousands or tens of thousands of records, wouldn't the query
be extremely slow?
Ken
> ----------
> From: Curt Newsome[SMTP:[EMAIL PROTECTED]]
> Sent: Friday, August 25, 2000 3:26 PM
> To: Ken Fioretti
> Subject: Re: MI Locate nearest...
>
> Ken, you can do this with an SQL query using the Distance function.
> If no
> one's sent you the "how-to" yet (the procedure is not very well
> documented
> in the books) let me know and I'll fill you in on it!
>
> Curt Newsome
>
> 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]
