Hi Steve,
I've had a similar problem using the createcircle function in the SQL
dialog. It turned out the problem was with the current distance units
setting in the map window....a previous statement of mine had changed the
units to meters from miles.
I believe the mapbasic statement to change this back is:
set map distance units "mi"
Cheers,
Chris
Chris DuBuc
[EMAIL PROTECTED]
>From: "Steve Wallace" <[EMAIL PROTECTED]>
>Reply-To: "Steve Wallace" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: MI-L SQL Select within Radius
>Date: Fri, 1 Jun 2001 13:21:09 -0400
>
>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.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
_______________________________________________________________________
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.
