i want to ask about erase outside in MapBasic. I have two table : sensus and voronoi And I want to erase the overlap areas. How can I do it?
This is my syntax
Select overlap(sensus.Obj,voronoi.Obj)
from sensus, voronoi
where sensus.Obj intersects voronoi.Obj
but that's indicates error 'The object in argument1 cannot be a point'
This is my full source code
'Create Table "voronoi"
(Block_no Char(15),Remark Char(10),Type_Palm Char(10),Ha Float)
File "D:\voronoi.TAB"
TYPE NATIVE Charset "WindowsLatin1"
Create Map For Voronoi CoordSys Earth Projection 1, 104
Set Table Voronoi FastEdit On Undo Off
Create Object As Voronoi from sensus Into Table voronoi
Update voronoi
Set Ha = Area(obj, "sq m")
Commit Table Voronoi
Set Table Voronoi FastEdit On Undo Off
select * from Voronoi
where Ha >= Val(inputnumber)
into __TO__UPDATE NoSelect
Set target on
Select overlap(sensus.Obj,voronoi.Obj)
from sensus, voronoi
where sensus.Obj intersects voronoi.Obj
Commit Table Voronoi
Close Table __TO__UPDATE
Create Index On voronoi (Block_no)
Add Map Layer voronoi
select * from Voronoi
where Ha >= Val(inputnumber)'
I want to eliminate the line outside the border. Please help me