All object types can be selected based on their type with the following: Select * from YourTable where str$(obj)="point"
"Point" can be substituted with Region, Polyline, Ellipse, Text, Rectangle, Arc and Rounded Rectangle Andrew Young Durham City Council UK -----Original Message----- From: Ahmed Saber [mailto:[EMAIL PROTECTED]] Sent: 22 September 2002 16:29 To: MapInfo-List (E-mail) Subject: RE: MI-L Selecting Points There is no direct statement that I know which can select objects based on there type. However a point is a geographic object with 0 length and area so.. Select * from Nadi_El_Seid where (Area(obj, "sq mi")=0) and (ObjectLen(obj, "mi")=0) into Selection The same can be applied to line objects: Select * from Nadi_El_Seid where (Area(obj, "sq mi")=0) and (ObjectLen(obj, "mi")>0) into Selection And polygon objects: Select * from Nadi_El_Seid where Area(obj, "sq mi")>0 into Selection Regards, Ahmed Saber GIS Expert MobiNil Cairo-Egypt +20 12 323 53 50 [EMAIL PROTECTED] -----Original Message----- From: Norm Shea [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 2:48 PM To: MapInfo-List (E-mail) Subject: MI-L Selecting Points Is there a way using an SQL query to select only point objects in a layer. I�m trying to separate the objects in a drainage layer (points for catch basins, lines for pipes) so I can export it to ArcView. Any ideas about that would be appreciated also. Norm Shea Director, Lakes Management Kiawah Island Community Association 20 Kestrel Court Kiawah Island, SC 29455-5657 843-768-2315 office 843-768-0298 fax 843-708-3608 mobile [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3182 IMPORTANT NOTICE: This e-mail is confidential. It must not be read, copies disclosed or used by any person other than the main recipient. Unauthorised use, disclosure or copying is strictly prohibited and may be unlawful. If you have received this e-mail in error, please contact the sender immediately.
