I want to run several queries in a row. However, I don't want them hardcoded in a program.

What I did was build a query statement (without the word SELECT at the beginning) within a memo field in a file.

In my program, I ran the code:

=====================================================

select queryfile
do while !eof('queryfile')

SELECT DISTINCT queryfile.qrymemo

{process something if query finds a hit}

skip 1 in queryfile
enddo

=====================================================

The field qrymemo is my memo field containing the SQL statement.

I'm just winging this. Does anyone know how I can run a SELECT statement and substitute in the body of the SQL statement?

Any and all help is greatly appreciated.

Rob