ha, very goodly. if it doesn't have a mappy thing associated with it, i don't use mapinfo to play with it, which is why i came up with my answer.
-----Original Message----- From: Ian Hull [mailto:[EMAIL PROTECTED] Sent: Monday, 14 July 2003 6:18 PM To: [EMAIL PROTECTED] Subject: RE: MI-L Reverse Selection 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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7654
