> Gineen,
I have to do similar selections when I need to find all of the zipcodes
within 3 miles of any store
Type the following into the mapbasic window...
dim mobj as object
Create Object As Buffer From <pointtable> Width <distance> Units "mi"
Resolution 12 Into variable mobj
Select * from <region> where obj intersects mobj
Replace <variables> with the correct values.
Ken Fioretti
> ----------
> From: Gineen Cation[SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 25, 1999 12:14 PM
> To: mapinfo-l
> Subject: Re: MI Selecting objects within a buffer
>
> Hello Listers,
>
> I have a quick question about selecting objects within a buffer.
> I have several point objects in one table with a 1 Km buffer
> surrounding
> each. I am trying to query all objects within
> a seperate table which fall within the 1 Km buffer. The SQL query
> worked
> for the most part, yet where the buffers overlap
> the results are not accurate. The query is only picking up the objects
> from the top most buffer.
>
> Is there any way to avoid this, perhaps without using a buffer.
>
> Gineen Cation
> TD Bank
>
> ----------------------------------------------------------------------
> 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]
