How to select objects from a table based on their object types in MapInfo Pro

UPDATED: April 18, 2017

A table may contain various objects such as text, polygon, line, points etc. and if a user wants to select any object based on their object type, he can follow the below steps:

In a Mapbasic window, MapBasic application or SQL Select, type the following:
Select * from <tablename> where Val(Str$(ObjectInfo(Obj,1))) =<OBJ_INFO_TYPE>

For example:
To extract the text objects from the table test.tab, type the following:
Select * from test where Val(Str$(ObjectInfo(Obj,1))) =10

Below is the screenshot from ObjectInfo() function MapBasic Help:
User-added image


  • No Downloads