Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I check whether a table is mappable?

I am trying to select all records from a table that contain objects, like this:

Select * From TableName Where Obj Into TempTable

If a table doesn't have an Obj column then this will cause an error. How can I check for the existance of the Obj column?

share|improve this question
up vote 3 down vote accepted

You can use the TableInfo() function to query a table for a number of attributes, one is whether it is mappable.


If TableInfo(TableName, TAB_INFO_MAPPABLE) Then
   Select * From TableName Where Obj Into TempTable
End if
share|improve this answer
Perfect. Thanks! – Mr_Chimp Dec 22 '11 at 16:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.