|
Christine,
Have you Indexed your column "Unique_ID? This may
speed things up.
Also, if the Mapper Window is open, maybe close it
(to save selection/redraw times)
Depending on your computer speed, RAM and the
number of records MapInfo has to troll through, you may easily be looking at
upwatds of an hour, a day, weekend, etc to get the results! And I'm not
joking.
Good luck,
Bill
=======================================================================================================
----- Original Message -----
Sent: Friday, March 17, 2006 6:41
AM
Subject: [MI-L] Editing and Queries
Thanks to Bill and Jaques for their replies on my
editing question. I started again following their suggestions and have a
clean file now. Next question!:
I've performed a query on a table by 'city' field
to find all patients that live in the Kelowna Area (Westbank, Rutland,
Peachland etc.) I now want to select all the patients in the table that
don't meet the original query requirements. I've used the following SQL
in the MapBasic Window
Select * from KGH_Patients Where Unique_ID NOT
IN (select Unique_ID from Kelowna_Patients)
and the operation seems to suspend every time, so I
have to close down the program and start again (I gave it up to 10
minutes)
Any thoughts? Thanks
Christine
_______________________________________________
MapInfo-L mailing
list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
| 