I assume you want to use Table->Update Column rather than MapBasic. First of all, the NODE columns in both tables must be indexed. HYD_NODES cannot be readonly.
1. Select Table->Update Column from the MapInfo menu. 2. select HYD_NODES for the "Table to Update". 3. select WATERMETER_CONSUMPTION_2005 for "Get Value from Table". 4. Select NODE_CONSUMPTION for the "Column to Update". 5. Select the JOIN button. 6. Select the radio button next to "where" and the NODE fields for the two tables. Click on OK. 7. in the popup menu after "Calculate", select "Sum". 8. In the popup menu next after "Of", select CONSUMPTION 9. Click on OK I can only go by the captions in the English version of MapInfo, but I assume that the controls are at least arranged the same way in your version. IF you want to use MapBasic (or just paste something into the MapBasic window) it's something like Add Column HYD_NODES (NODE_CONSUMPTION) from WATERMETER_CONSUMPTION_2005 set to sum(CONSUMPTION) where NODE=NODE Hope this helps Spencer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nebojsa Pesic Sent: Thursday, June 15, 2006 6:11 AM To: [email protected] Subject: [MI-L] how to perform update column ? Hello , Please help me. I got two tables, a i b. a. WATERMETER_CONSUMPTION_2005.TAB Table represents watermeter location and its single consumption per year. Consumption is entered in field CONSUMPTION. Now, every watermeter belong to nearest hydraulic node.(see map!) Number of node is in field NODE. b. HYD_NODES.tab Table represents hydraulic nodes. Node number is entered in field NODE. This table also have field NODE_CONSUMPTION which represent my problem here. In that field i have to sum all consumptions of watermeters which belong to the same node (which falls in coloured area on my map). HOW to perform -update column- and automatically finish this task ? Is it possible to do it in one step ? see my map for better understanding: http://geocities.com/neboysh/node_consumption.gif cyan dotes are watermeters labeled with consumption blue square is node with labeled cumulative consumption for that node. I have more than 40000 watermeters in table and this will be real time saver ! thanks -- Nebojša Pešić, Dipl. Ing Department for GIS development & Hydraulic Modelling JKP "Naissus", Waterworks and Sewerage company of Niš Serbia office: +381 (0)18 502 633 mobile: +381 (0)64 345 77 55 mailto:[EMAIL PROTECTED] _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
