[GIS] MapBasic sentence to update column contained in an object table

attribute-joinsmapbasicmapinfotable

I was looking for a MapBasic sentence to update a MapInfo table. I've got two tables and I want to update one of them (POINTS) with an attribute of another (REGIONS). I would like to update points with the name of the regions contained.
I mean, I have two tables in MapInfo, a polygons table and a points table. I want to fill the column "municipality" with the names of the polygons which contain the points.

I was trying with different possibilities, using the command "update" such as

Update {Text Table} Set {Column}=ObjectInfo(Obj,3) 
 Select * From {Text Table} Where Str$(Obj)=”TEXT”

Best Answer

Table POINTS (with column REGION_NAME),

Table REGIONS (with column NAME)

Add Column "POINTS" (REGION_NAME) From REGIONS Set To NAME Where contains

You should replace names for your actual tables and columns.

Related Solutions

[GIS] Check if an object is empty in mapbasic

Query For Selecting row(s) without object :

    Select * from 'MYTABLE' where not obj into MYTABLE_NO_MAP_OBJECT   
    Browse * From MYTABLE_NO_MAP_OBJECT

Query For Selecting row(s) with object :

     Select * from MYTABLE where obj into MYTABLE_MAP_OBJECT
     Browse * From MYTABLE_MAP_OBJECT

[GIS] Compare two tables. Show values only in one table

Let's say we have two tables: Tab1 with field Field1, Tab2 with field Field2.

We want to select records from Tab1 which Field1 values is not present in Field2 of Tab2.

In MapInfo: menu Query->SQL Select...

Columns: *
from Tables: Tab1
where Condition: not Field1 in (select Field2 from Tab2)

In MapBasic window it will be: Select * from Tab1 where not Field1 in (select Field2 from Tab2) into Selection

Best Answer

Related Solutions

[GIS] Check if an object is empty in mapbasic

[GIS] Compare two tables. Show values only in one table

Related Question