Group of queries-from an earlier thread answered by John W. Vinson

[Beginner]

I have a table imported from an excel spreadsheet and is
joined with several other tables and manipulated according
to the business rules in order to obtain the end result in
a format the customers would understand. But for this
process, the exceptions have made their way as rules and I
have incorporated them into series of queries as defining
them into a table is almost impossible. These queries in
course of time have become large in number and so I was
thinking about a way to have them all in a particular
order in a single file to ease the maintanence.

I had this idea of compiling them and saving them as .sql
file - but have no idea as to where to save them and call
them through RunSQL action/method.
I appreciate your curiosity. I can't exactly figure out to
work it the way you have specified and will be glad if you
could help me.

Thanks
Sripriya

Thank you for your response. This will still require to
maintain the queries. I would like to know if we could
consolidate all queries into a file and then run the file
so that the individual queries can be eliminated from the
database .

You could store the actual SQL string of the queries in a
text (or
Memo, if they exceed 255 bytes) field in the query table,
and use the
RunSQL method to execute them as you step through the
table. Never
done it but it should work!

I'm curious why you have a repetitive need to execute
multiple action
queries; just what are they doing?


..