Hi Philip, If we assume you only have access to mapbasic as a development tool, you could this approach (pseudo code style):
First some SQL: select ID, 0 "found" from roadtable group by ID into tmptable add index on field ID in table tmptable loop through all records in roadtable: locate record with roadtable.ID from tmptable if found=0 then set field found=1 else delete record from roadtable move to next record in roadtable Probably quite slow, but the best I can come upon with resolving to external dll's. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, January 27, 2005 8:35 PM Subject: MI-L Duplicate Records Query Group, Can anyone give me a heads up on how to eliminate duplicate records in M 7.5. I'm making a new nation wide roads layer and there will be about 300,000-500,000 duplicate records because of the way I've been given the tab files. Each road segment has its own id number. Thanks -------------------------------------------------------------------- Philip Lesnik Research Systems Analyst, Market Research General Growth Properties, Inc. 110 N. Wacker Drive BSC 3-13 Chicago, IL 60606 312-960-2998 312-960-5519 (fax) [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15045
