Steve,
Just a stab in the dark, but do you need to add the 'ANY' keyword in the
select statement?...
where anytable.obj within Any
CreateCircle(CentroidX(obj),CentroidY(obj),"50")
Keith
-----Original Message-----
From: Steve Wallace [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 18:21
To: [EMAIL PROTECTED]
Subject: MI-L SQL Select within Radius
Help! Why won't this work? It used to!
Select Location, sum(price), sum(cost)
from anytable
where anytable.obj within
CreateCircle(CentroidX(obj),CentroidY(obj),"50")
group by Location
order by Location
into Selection
Steve Wallace
Florida Farm Bureau Insurance Companies
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
This email and any attached files are confidential and copyright protected.
If you are not the addressee, any dissemination of this communication is
strictly prohibited. Unless otherwise expressly agreed in writing, nothing
stated in this communication shall be legally binding.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
