Ash,
That method will not work if the objects intersect (obviously) which
include objects which share a common point e.g. two roads at a junction or
a boundary file. It also won't work if some records don't have map objects.
The best way is to use a unique field on the table. (If you haven't got a
unique field you can easily add a new column and update it with rowid).
Then you can use
select * from MYTABLE where MYTABLE.UniqueField <> all(select UniqueField
from selection)
Regards,
Ian Hull
Greater Manchester Transportation Unit
Salisbury House
Granby Row
Manchester
M1 7AH
Tel: 0161 455 2059
Fax: 0161 455 2071
E-mail: [EMAIL PROTECTED]
"Simmonds, Ashley
(PTB)" To: "'Mapinfo List
(E-mail)'"
<[EMAIL PROTECTED] <[EMAIL PROTECTED]>
.sa.gov.au> cc:
Subject: RE: MI-L Reverse
Selection
14/07/2003 03:30
i think this werks to invert selection, but it's kinda slow sometimes.
#############################
Select * from TABLENAME where not(obj intersects any(select obj from
selection)) into Selection2
#############################
ash
-----Original Message-----
From: Bob Regier [mailto:[EMAIL PROTECTED]
Sent: Saturday, 12 July 2003 4:42 AM
To: [EMAIL PROTECTED]
Subject: MI-L Reverse Selection
Hi,
I am running MapInfo 6.0 and I would like to be able to reverse a
selection (e.g. unselect the selected polygons and select the unselected
ones) I know this functionality is built into more recent versions, but
I wondered if there is a utility I can use with 6.0?
Thanks,
Bob
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 7607
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 7613
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept
for the presence of computer viruses.
Please contact [EMAIL PROTECTED]
with any queries.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 7616
