By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

Action Queries In Series

P: n/a
If a subroutine runs twelve action queries, will they run one-at-a-time
where one finishes before the next one starts or will one or more run
simultaneously? If they don't run one-at-a-time, how can they be made to do
it?

Thanks!

Steve
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
PC Datasheet wrote:
If a subroutine runs twelve action queries, will they run
one-at-a-time where one finishes before the next one starts or will
one or more run simultaneously? If they don't run one-at-a-time, how
can they be made to do it?

Thanks!

Steve


They will be run in series with each one waiting until the preceeding one is
finished. In general you have to go out of your way to make code statements NOT
behave this way.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
If your concern is that all the queries succeed of fail, wrap them in a
transaction, then commit or rollback based on the success of all the
queries.

"PC Datasheet" <no****@nospam.spam> wrote in message
news:iL*************@newsread2.news.atl.earthlink. net...
If a subroutine runs twelve action queries, will they run one-at-a-time
where one finishes before the next one starts or will one or more run
simultaneously? If they don't run one-at-a-time, how can they be made to do it?

Thanks!

Steve

Nov 13 '05 #3

P: n/a
Thanks, Ron!

That wasn't my initial concern but I am going to apply your suggestion.

Steve
"paii, Ron" <pa**@packairinc.com> wrote in message
news:Qf********************@athenet.net...
If your concern is that all the queries succeed of fail, wrap them in a
transaction, then commit or rollback based on the success of all the
queries.

"PC Datasheet" <no****@nospam.spam> wrote in message
news:iL*************@newsread2.news.atl.earthlink. net...
If a subroutine runs twelve action queries, will they run one-at-a-time
where one finishes before the next one starts or will one or more run
simultaneously? If they don't run one-at-a-time, how can they be made to

do
it?

Thanks!

Steve


Nov 13 '05 #4

P: n/a
Thanks, Rick, for the quick response!

I have seen in the newsgroups posts saying something in a procedure happens
before something preceding is finished. Is that contrary to what you say?

I have also seen recommendations in the newsgroup to use Do Events to allow
something to complete before another thing happens. Is that contrary to what
you say?

Steve
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:aT******************@newssvr14.news.prodigy.c om...
PC Datasheet wrote:
If a subroutine runs twelve action queries, will they run
one-at-a-time where one finishes before the next one starts or will
one or more run simultaneously? If they don't run one-at-a-time, how
can they be made to do it?

Thanks!

Steve


They will be run in series with each one waiting until the preceeding one
is finished. In general you have to go out of your way to make code
statements NOT behave this way.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #5

P: n/a
"PC Datasheet" <no****@nospam.spam> wrote in message
news:lj*************@newsread2.news.atl.earthlink. net...
Thanks, Rick, for the quick response!

I have seen in the newsgroups posts saying something in a procedure
happens before something preceding is finished. Is that contrary to what
you say?

I have also seen recommendations in the newsgroup to use Do Events to
allow something to complete before another thing happens. Is that contrary
to what you say?


Do Events forces a yield to the operating system.
Nov 13 '05 #6

P: n/a
If you use docmd to open a form, docmd will return before the form is done
opening, unless opened it as a dialog box. You could create 12 forms with
one of the action queries in the on open event. Then open each form in your
function. I would bet that Access would slow to a crawl and/or crash if you
tried it.

"PC Datasheet" <no****@nospam.spam> wrote in message
news:lj*************@newsread2.news.atl.earthlink. net...
Thanks, Rick, for the quick response!

I have seen in the newsgroups posts saying something in a procedure happens before something preceding is finished. Is that contrary to what you say?

I have also seen recommendations in the newsgroup to use Do Events to allow something to complete before another thing happens. Is that contrary to what you say?

Steve
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:aT******************@newssvr14.news.prodigy.c om...
PC Datasheet wrote:
If a subroutine runs twelve action queries, will they run
one-at-a-time where one finishes before the next one starts or will
one or more run simultaneously? If they don't run one-at-a-time, how
can they be made to do it?

Thanks!

Steve


They will be run in series with each one waiting until the preceeding one is finished. In general you have to go out of your way to make code
statements NOT behave this way.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #7

P: n/a
Keith wrote:

Do Events forces a yield to the operating system.


That's only part of it, the API Sleep function does that also but the
other thing about DoEvents is that it allows your application to process
messages from the OS (Mouse Clicks, keystrokes, etc).
Nov 13 '05 #8

P: n/a
PC Datasheet wrote:
If a subroutine runs twelve action queries, will they run one-at-a-time
where one finishes before the next one starts or will one or more run
simultaneously? If they don't run one-at-a-time, how can they be made to do
it?


It's sequential unless you are using ADO against a SQL Server and use
Asynchronous calls to the queries.
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.