Hi there I'm assuming you don't have mapbasic, but what you could do is open the mapbasic window and go through the whole process. This will record all the necessary mapbasic statements (including the 'commit table' statements) which you can then save as a text file. Then, after that, you only need to paste the text file into the mapbasic window again, highlight it and hit enter to run the process again.
You can even dim variables in the mapbasic window to hold table names/ paths etc if you need to - just remember to undim them at the end. Try it out on something smaller to get the general idea. Steve McArthur LLPG Manager London Borough of Hackney Tel: 020 8356 2061 E-mail: [EMAIL PROTECTED] -----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. London Borough of Hackney may exercise its right to intercept any communication on its networks - for more information see http://www.hackney.gov.uk/email_disclaimer.html --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13562
