Erik,
polygons have an 'area', lines do not,  so try something like

select * from mytab where area(obj, "sq m") <> 0

will select all polygons from table mytab

to find lines from points (points also have an area of 0m2)

select * from mytab where objectlen(obj, "m") <> 0


the 'area' and 'objectlen' functions are found on the sql-query dialog only



regards


russ lawley
brit geol surv
uk


-----Original Message-----
From: Erik van Hunnik [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2001 21:47
To: [EMAIL PROTECTED]
Subject: MI-L how to select polygons in a layer


Dear list,

I want to filter out all polygons in a layer that has both polylines and
polygons in it.
I tried the ObjectInfo(obj, 1) function, and could get the information on
what the object is. With the result I didn't succeed in making a next query
that should filter out those objects.

Thanks for your input.

Erik van Hunnik
First Element
[EMAIL PROTECTED]



_______________________________________________________________________
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.



_______________________________________________________________________
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.

Reply via email to