Vinesh, i posted the qiksubset tool on the directionsmag and muguki sites to do this kind of subsetting via a column, you can opt for temporary queries or permanently saved subsets.. source is included.
regards r -----Original Message----- From: Vinesh Govind [mailto:[EMAIL PROTECTED] Sent: 01 October 2004 11:23 To: MapInfo Lists (E-mail) Subject: MI-L Automated SQL Query MapInfo Users I have a dataset containing 55000+ records. One of the columns in my TAB file is "classification code". By writing a SQL query I am able to filter the TAB file to provide me with just a 'selected set' of records based on the classification code. However, as I need to do this possibly more than 50 times (create 50 layers!!) I was wondering if there was an "automation process" that I could use such that whenever I received an update to the dataset from our suppliers I could run a query that would produce 50 different layers based on my classification code. A colleague suggested writing a macro but forgive my ignorance as I don't know where to start. I also thought that I may be able to write a SQL select statement that would be saved as a template, though I am unsure how this would split the tables! Can anyone help? Thanks. Vinesh _______________________________________________________________________ The contents of this message do not necessarily represent the opinions, views, policy or procedures of Leicestershire County Council. ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. However, the information contained in this e-mail may subsequently be subject to public disclosure under the Freedom of Information Act 2000 and, unless the information is legally exempt from disclosure, the confidentiality of this e-mail and your reply cannot be guaranteed. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. http://www.bgs.ac.uk ********************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13558
