RE: MI-L Property Areas

2004-07-05 Thread Solominides, Peter
Hi all, Quick question, has anyone had any problems transferring tools from Mapinfo 6.5 to Mapinfo 7.5? The tool was created in Mapbasic 5.5, and while some aspects works fine, the parts of the tool that reference OS tiles don't work, and display an error message saying 'Could not convert

RE: MI-L Property Areas

2004-06-18 Thread Solominides, Peter
I have this code to update the Commercial_Property_Type column of the table Edit with the area of a polygon from the table Cpa. However when I run the tool it brings up an error message telling me the variable or field Edit.obj is not defined. Any thoughts/derision welcome. Cheers P Fetch First

Re: MI-L Property Areas

2004-06-09 Thread Soren Breddam
Hi Peter, You should try the "Add Column" command: Add Column "YourPointTable" (Property_Area) From YourPolygonTable Set To AreaColumn Where contains or Add Column "YourPointTable" (Property_Area) From YourPolygonTable Set To Area(obj,"sq m") Where contains HTH Soren Breddam -Oprindelig me

RE: MI-L Property Areas

2004-06-09 Thread Terry McDonnell
Peter It would help if you said how MI doesn't like it. I'm fairly new to MB but not to SQL. Presumably not ALL the points in the points table are within the SAME polygon. I should think your select statement is a bit vague. How does MB know which obj within the polygon table? Similarly your