Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    13

    Unanswered: how to automate several query

    Hi all
    if somebody can help me with this it will be great

    My situation is I have more than 300 table with exactly the same structure
    for each table I would need to run exactly the same 2 select queries and 3 update queries and exactly at the same order (i.e. you need to run the first two select queries and then continue with the other 3 one by one)

    To do it one by one is causing me a headaches , Do you know if there's a way I can automated those queries for all the table?


    Thanks in advance



    Charly

  2. #2
    Join Date
    Sep 2004
    Posts
    161
    You can utilisee the tabledefs collection and to pass the name of each
    tabledef in parameter to the query.

  3. #3
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    My situation is I have more than 300 table with exactly the same structure
    This begs the question why you don't put all 300 tables into one table. Then you get the full value of using a database. Otherwise, as you're seeing, you have to resort code each time you want some new info.
    Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •