Recording Macro/Script in Paradox 8

mcornbill · #1 (**permalink**) 03-19-04, 06:28

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

lmckelvy · #2 (**permalink**) 03-19-04, 09:23

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)

Internet Services

Web Development

Digital Marketing

Consumer Tech