How to check if sproc has finished

[Robert]

I have an Access 2007 ADP database using SQL Server 2008 Express and I need
to run several queries in succession. I am using code such as

Docmd.RunSQL "Exec sproc1 @p1, @p2 etc....
Docmd.RunSQL "Exec sproc2 @p1, @p2 etc....

I need to have some way to test if the first one has finished before the
second one starts. How can I do this?

 

[Bob McClellan]

Robert,
I would use ADO with an output param to get results.
If you opt not to do that then why not have one stored proc that
executes the others....

Create Proc sproc_Main
@p1 int --(or whatever),
@p2 int --(or whatever)
as
exec dbo.sproc1 @p1, @p2 etc....
exec dbo.sproc2 @p1, @p2 etc....


...bob

 

[Robert]

Robert,
I would use ADO with an output param to get results.
If you opt not to do that then why not have one stored proc that
executes the others.... ADO? How would I use ADO?

Create Proc sproc_Main
@p1 int --(or whatever),
@p2 int --(or whatever)
as
exec dbo.sproc1 @p1, @p2 etc....
exec dbo.sproc2 @p1, @p2 etc....


..bob

 

[Bob McClellan]

ADO? How would I use ADO?
here is an example...

Dim oCmd As Command, param As Parameter
Dim cn As New ADODB.Connection, sqlString As String

sqlString = "NewJobSites_CheckCount" 'PROC:
NewJobSites_CheckCount
Set oCmd = New ADODB.Command
Set cn = CurrentProject.Connection
Set oCmd.ActiveConnection = cn
oCmd.CommandText = sqlString
oCmd.CommandType = adCmdStoredProc
oCmd.CommandTimeout = 15


Set param = New ADODB.Parameter
param.Type = adInteger
param.Direction = adParamOutput
param.Name = "cnt" 'RETURN: Authenticated Flag
oCmd.Parameters.Append param

Me.JobCount = oCmd.Parameters("cnt")
oCmd.Execute , , adExecuteNoRecords

Set cn = Nothing

 

[Marco]

Friends and friends around the world.
We are presenting the new messenger.
He will be in the commissioning by the friends that we indicate to use the
system.
Access the system by clicking the link below and register free.

You get something for using orkut?
You get something for using skype?
You gain something by using twiter?
You get algumaocisa for using facebook?

Enjoy this is your time!!

Sign up and join for free.


http://www.sqipcom.com/?ref=webempreendedor

http://stakeholder.sqipcom.com/user/webempreendedor

 

[Robert]

Thanks. So if an sproc calls 2 other sprocs the second one doesn't start
until the first one has finished?

 

[vaslerio]

I have an Access 2007 ADP database using SQL Server 2008 Express and I
need
to run several queries in succession. I am using code such as

Docmd.RunSQL "Exec sproc1 @p1, @p2 etc....
Docmd.RunSQL "Exec sproc2 @p1, @p2 etc....

I need to have some way to test if the first one has finished before the
second one starts. How can I do this?

 

[Guest]

I have an Access 2007 ADP database using SQL Server 2008 Express and I
need
to run several queries in succession. I am using code such as

Docmd.RunSQL "Exec sproc1 @p1, @p2 etc....
Docmd.RunSQL "Exec sproc2 @p1, @p2 etc....

I need to have some way to test if the first one has finished before the
second one starts. How can I do this?