There is a big difference between Save Copy as and Save Query. Save Copy As makes a copy of your data in a new table. This could also be usefull when changing the data source eg. from txt to MI Tab and when you need to change the projection of your table. Once you have made a Save Copy As the copy has no connection to the original table.
Save Query will allways be connected to the original table and therefor it's a dynamical way of updating a query often used. When you use Save Query what is actually saved is a TAB file and a QRY file. The TAB file knows which table(s) to open to perform the query and the QRY file knows which SQL statement to perform. So when you afterwards open the TAB file, this TAB file is aware that it's not a normal TAB file but a "Query Table". Within the TAB file is mentioned which table(s) to open and these are open - if not allready - and then MapInfo executes the SQL statement within the QRY file resulting in a query named a the selected TAB file. In my opinion the Save Query is an overlooked feature. But I also think it has to be fixed in a few places: 1. If you want to save this Query table to your workspace, do remember to turn on the option under Preference > Startup > Save queries in workspaces. 2. When the Query table is save to the workspace it save as the SQL statement and not as the reference to the TAB file. So MapInfo doesn't "know" whcih query was opened usig a Query TAB and which just was a temporary query executed using the SQL Select 3. The TAB files references in the TAB file are allways written using absolute paths, not relative as within the workspace. HTH, Peter Horsb�ll M�ller GIS Developer COWI A/S - Geografisk Information & IT Rug�rdsvej 55 DK 5000 Odense C Tel +45 6313 5013 Direct +45 6313 5008 Mobil +45 2270 4308 Fax +45 6313 5090 Kampsax blev i juni 2002 overtaget af COWI. I forbindelse med den igangv�rende integrationsprocess udskiftes vores Kampsax e-mail adresser med COWI e-mail adresser.Hjemmesideadresser forbliver u�ndrede > -----Original Message----- > From: James Lee [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 24, 2003 5:30 AM > To: [EMAIL PROTECTED] > Subject: MI-L save query vs save copy as > > > hi! can someone please lighten me up with the function save > query and save > copy as option. > > after u have performed a SQL query you have the option to use > both above > options. whats the difference??? which one does most of u adopt? > > james > > > _________________________________________________________________ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > Message number: 5130 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5131
