Hi Cameron,
 
In the  Mapbasic window, i would try this, assuming that your base table
is called "data"
and the variable to sum "varnum" :

set distance units "m"
Commit Table data As "C:\TMP\data1.TAB" TYPE NATIVE Charset
"WindowsLatin1" 
Open Table "C:\TMP\data1.TAB" Interactive
drop map data1
Create Map For data1 CoordSys NonEarth Units "m" Bounds (-10000, -10000)
(10000, 10000)
Add Column "data1" (_rowid integer) From data1 Set to rowid
update data1 set obj=createcircle(0,0,rowid)
Commit Table data1 As "C:\TMP\data2.TAB" TYPE NATIVE Charset
"WindowsLatin1" 
Open Table "C:\TMP\data2.TAB" Interactive
Select data1._rowid, sum(data2.varnum) "csum" from data1, data2 where
data2.obj entirely within data1.obj group by 1 into dt_csum
 
It's a little weird and time-consuming, but useful when you don't have
Mapbasic 
 
Hope this helps,

Eric Mauvi�re
EMC3   <http://www.geoclip.net> www.geoclip.net
214 B Ch des Izards 31140 Launaguet
France

Reply via email to