>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

Use the '&string' for this. I've never tried an entire SELECT '&etc', but it works for parts of it.