Information générale
Titre:
SELECT - SQL command run over records in a file?
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement