I
Ivan Mascovich
I have sequence of update queries I need to execute to set up a databased.
How can I execute other than entering them one at a time?
How can I execute other than entering them one at a time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
TedMi
Depends on how similar the queries are to each other. If they differ only in
table and filed names, you could set up a loop in VB code to construct each
query and execute it - provided you can formulate some logical rule on how to
generate the table names, field names and update values (eg. for every table
in the database, get the name of the Nth field and update it to zero).
Otherwise, setting up the arrays to drive this process could be more work
that just writing each query by hand and executing it.
table and filed names, you could set up a loop in VB code to construct each
query and execute it - provided you can formulate some logical rule on how to
generate the table names, field names and update values (eg. for every table
in the database, get the name of the Nth field and update it to zero).
Otherwise, setting up the arrays to drive this process could be more work
that just writing each query by hand and executing it.
J
Jeff Boyce
Ivan
Not sure what you mean by "entering them one at a time"?
Do you already have the queries built, and are trying to run the sequence?
If so, you could run the set of them in a procedure, or in a macro.
Not sure what you mean by "entering them one at a time"?
Do you already have the queries built, and are trying to run the sequence?
If so, you could run the set of them in a procedure, or in a macro.
I
Ivan Mascovich
Ivan
Not sure what you mean by "entering them one at a time"?
Do you already have the queries built, and are trying to run the
sequence? If so, you could run the set of them in a procedure, or in a
macro.
I have a file containing a sequence of queries. I would like to execute
them in sequence.
If I copy them into the SQL window of the query editor, access does not
like one query after another.
J
Jeff Boyce
Ivan
As my previous response suggested, make them into a series of queries, then
use a procedure or macro to run them sequentially.
As my previous response suggested, make them into a series of queries, then
use a procedure or macro to run them sequentially.