Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Recording Macro/Script in Paradox 8

    Hi all

    I have to run 4 queries and save the answer after each one every week. Is there like a macro function whereby it will run the four one after each other and then save the answers itself to whatever I want to call them.

    Cheers
    Mark

  2. #2
    Join Date
    Oct 2003
    Posts
    107
    Yes, you can do that. Design your queries and save them. Then in your script, you simply paste them into the code (using EDIT->PASTE FROM). In it's simplest form it would look something like this:

    Code:
    var
    
    qVar   query
    
    endvar
    
    ;the PASTE FROM starts immediately after "qVar ="
    
    qVar =  Query
    
    :myAlias:MyDb.DB | Code   | Description | 
    
                                |Check  | Check       | 
    
    EndQuery
    
    qVar.executeQBE(":priv:answer.db") ;you can change this to be a different table name and location.
    
    ;(repeat 3 more times)
    Last edited by lmckelvy; 03-19-04 at 12:11.

Posting Permissions

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