Brandi. Try this MapBasic code. If you do not have MapBasic, let me know & I can send you this compiled code.
Kathy GeoSolutions Consulting Inc. 38 Auriga Drive, Unit 3 Ottawa, Ontario, Canada K2E 8A5 Toll free: 1-877-471-2226 Ph: (613) 727-7563 ext. 402 Fx: (613) 727-3210 [EMAIL PROTECTED] http://www.geosolutions.com <http://www.geosolutions.com/> http://mapinfo.geosolutions.com <http://mapinfo.geosolutions.com/> ========================================================================= Include "Mapbasic.def" Dim i as Integer Dim firstobj as object For i = 1 to TableInfo(table2, TAB_INFO_NROWS) Fetch rec i from table2 firstobj = table2.obj select * from testrd where ObjectGeography(firstobj, OBJ_GEO_LINEBEGX) = ObjectGeography(table1.obj, OBJ_GEO_LINEBEGX) and ObjectGeography(firstobj, OBJ_GEO_LINEBEGY) = ObjectGeography(table1.obj, OBJ_GEO_LINEBEGY) and ObjectGeography(firstobj, OBJ_GEO_LINEENDX) = ObjectGeography(table1.obj, OBJ_GEO_LINEENDX) and ObjectGeography(firstobj, OBJ_GEO_LINEENDY) = ObjectGeography(table1.obj, OBJ_GEO_LINEENDY) into temp Delete from temp Next -----Original Message----- From: Brandi McGunigal [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 10:36 AM To: MapInfo List Subject: MI-L Identical lines in different layers List, How do I determine if lines in two different layers are exactly the same? Table1 has lots of lines, Table2 has some lines that are identical. I would like to eliminate the lines from table1 that match the lines in Table2. These lines do not have the same attributes. Thanks in advance. Brandi McGunigal GIS Technician Traxis Inc. Saskatoon, SK (306) 978-0445 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.461 / Virus Database: 260 - Release Date: 3/10/2003 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 6114
