Action Queries In Series

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

re: Action Queries In Series

PC Datasheet wrote:[color=blue]
> 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[/color]

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

re: Action Queries In Series

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" <nospam@nospam.spam> wrote in message
news:iLJ7f.379$2y.18@newsread2.news.atl.earthlink. net...[color=blue]
> 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[/color]
do[color=blue]
> it?
>
> Thanks!
>
> Steve
>
>[/color]

re: Action Queries In Series

Thanks, Ron!

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

Steve


"paii, Ron" <paii@packairinc.com> wrote in message
news:QfidnXUzPaGr6cLeRVn-ug@athenet.net...[color=blue]
> 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" <nospam@nospam.spam> wrote in message
> news:iLJ7f.379$2y.18@newsread2.news.atl.earthlink. net...[color=green]
>> 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[/color]
> do[color=green]
>> it?
>>
>> Thanks!
>>
>> Steve
>>
>>[/color]
>
>[/color]

re: Action Queries In Series

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" <rickbrandt2@hotmail.com> wrote in message
news:aTJ7f.18757$6e1.7303@newssvr14.news.prodigy.c om...[color=blue]
> PC Datasheet wrote:[color=green]
>> 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[/color]
>
> 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
>[/color]

re: Action Queries In Series

"PC Datasheet" <nospam@nospam.spam> wrote in message
news:ljL7f.419$2y.99@newsread2.news.atl.earthlink. net...[color=blue]
> 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?
>[/color]

Do Events forces a yield to the operating system.

re: Action Queries In Series

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" <nospam@nospam.spam> wrote in message
news:ljL7f.419$2y.99@newsread2.news.atl.earthlink. net...[color=blue]
> Thanks, Rick, for the quick response!
>
> I have seen in the newsgroups posts saying something in a procedure[/color]
happens[color=blue]
> 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[/color]
allow[color=blue]
> something to complete before another thing happens. Is that contrary to[/color]
what[color=blue]
> you say?
>
> Steve
>
>
> "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
> news:aTJ7f.18757$6e1.7303@newssvr14.news.prodigy.c om...[color=green]
> > PC Datasheet wrote:[color=darkred]
> >> 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[/color]
> >
> > They will be run in series with each one waiting until the preceeding[/color][/color]
one[color=blue][color=green]
> > 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
> >[/color]
>
>[/color]

re: Action Queries In Series

Keith wrote:[color=blue]
>
> Do Events forces a yield to the operating system.[/color]

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).

re: Action Queries In Series

PC Datasheet wrote:[color=blue]
> 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?[/color]

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