Removal of dups
first create a new integer column on your table and call it ID
Map Basic commands:
1) update <<Your Table>> set ID = RowID
2) select max(ID) ,
left$(str$(objectnodex(obj,1,1))+str$(objectnodey(obj,1,1))+str$(objectnodex
(obj,1,objectinfo(obj,22)))+str$(objectnodey(obj,1,objectinfo(obj,22)))+str$
(objectlen(obj,"m")),80) "COORDREF", Count(*) from <<Your Table>> group by
coordref
3) You may have to save the query1 table for the next bit
4) Select * from <<Your Table>> where id = any(Select _col1 from query1)
note the _col1 should be the max(ID) column from the select statement.
the selection in step 4 is the map table without dups. If you wants the
dups in a map use a join between the new table and the old one.
Hope this helps
Ian
----- Original Message -----
From: Petr Grinshpun <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 06, 2000 9:35 PM
Subject: MI Remove dups
> Hi mappers,
> Does anybody know how to remove duplicate records from a mappable table
> and get a mappable resulting table.
> Any idea would be greatly appreciated.
> Thank you.
> Petr Grinshpun,
> Senior System Analyst,
> LDS, Inc.
> 703-741-7094
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
