RE: [MI-L] Editing and Queries

Robert Crossley Thu, 16 Mar 2006 18:22:45 -0800

Title: Editing and Queries

Christine,

Sometimes its quicker to do a select query first and then use the inverse selection tool or command

Select * from KGH_Patients Where Unique_ID = Any (select Unique_ID from Kelowna_Patients)

Then do use the invert selection tool

-------------------------------------------

Robert Crossley

Agtrix P/L Australia

Far Southern Queensland Office:

9 Short Street

PO Box 63

New Brighton 2483

P: 61 2 6680 1309

F: 61 2 6680 5214

E: [EMAIL PROTECTED]

W: www.agtrix.com

Brisbane Office:

109 Milsom St

Cooparoo 4151

Queensland

P: 61 7 3843 3363

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Data Directions
Sent: 17 March 2006 10:24
To: Ronning, Christine; [email protected]
Subject: Re: [MI-L] Editing and Queries

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 -----

From: Ronning, Christine

To: [email protected]

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

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

RE: [MI-L] Editing and Queries

Reply via email to