Hi experts, A drill hole data base, a mappable table of drill hole locations, a non mapabble table with depth From and To and rock type (Kilm_dhlitho). A non mappable table used to compile statistics on the drill hole data base. Run a query on the rock type table to determine how many entries there are for each individual drill hole, of the form Select HoleID,Count(*) from Kilm_dhlitho group by 1 into Selection Browse * From Selection And then up date the statistics table using Table Update Add Column "Kilm_dh_cheklist" (Entries_dhlitho )From Query9 Set To COL2 Where COL1 = COL1 COL 1 in both instances containing the drill hole number. This works ok, BUT, order the query by the hole number as follows Select HoleID,Count(*) from Kilm_dhlitho group by 1 order by 1 into Selection Browse * From Selection and updating from the query puts data in the wrong place. Save the ordered query as a table and then open that table and update from it, it works correctly. What is going on ? Brendan O'Donovan Senior Exploration Geologist Outokumpu Tara Mines Ireland. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
