Dan,
Using SQL tips from Bill Thoen and Mikhail Soloviev, I wrote an MB
app that answers the problem you asked below.
>"I selected objects on a map and want to see all the records that are not
selected.
>Is there any easy way of listing the records that are NOT selected in a
table?"
The program is called InvertSelection.mbx and does just that. The
program analyzes the current selection and then selects all the records in
that table that are not currently selected.
For mappable tables the program uses finds all the objects not found
in the current selection using the following SQL statement.
select * from sourcetab where not obj intersects any (select obj
from seltab)
For unmappable tables, the program searches for a field with unique
values in it and then selects all records from the source table that don't
have any of the unique values of the currently selected records. The
following SQL statement is used.
select * from sourcetab where UniqueField <> all(select UniqueField
from seltab)
I tested this little puppy, but I won't be surprised if some bugs pop up.
The source code is attached for review. The program was written using MB
5.0. Any suggestions from the list would be graciously accepted and
appreciated.
John C. Hollingsworth
Director of GIS Programming
The Buxton Company
[EMAIL PROTECTED]
InvertSelection.MBX
InvertSelection.mb
