Andrew,
 
The following respects the required syntax for MapBasic window and SQL requester. If you are programming in MB, you could replace (obj,1) by (obj,obj_info_type)
 
select * from table1 where val(objectinfo(obj,1))=1 into selection
 
object types are
 
1 (arc) 2 (ellipse/circle) 3 (line) 4 (polyline) 5 (point) 6 (layout fframe) 7 region) 8 (rectangle) 9 (rounded rect) 10 (text)
 
Jacques Paris
============================================================
e-mail        [EMAIL PROTECTED]   
   alternate   [EMAIL PROTECTED]
 
gis activity (MapInfo mainly)
      http://www.total.net/~rparis/gisproducts.htm
============================================================
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andy
Sent: July 15, 1999 6:59 AM
To: mapinfo mailing list
Subject: MI Selecting using object type in an assorted table

Imagine a table holding points, polylines and regions (polygons in the real world). Is there a one-stop method for sql selecting all the points, or all the lines etc..
 
I can do it in a two-stop method; as below;
 
Select id, obj from table1 into Selection
Browse * From Selection
 
and then;
 
Select id from table1 into Selection
Where table1.Object = "Point"
Browse * From Selection
 
A free rude joke (from Chad) to anyone who can come up with an answer
 
regards,
Andrew Bailey
 

Reply via email to