H
habibi
Hello! The next procedure:
CREATE proc habibi_ac_test
as
raiserror('Some message...',16,1) with nowait
WAITFOR DELAY '00:00:10'
select top 5 * from documents
GO
The client program use ADO to access data.
My client application raises error only after 10 seconds...
I think it will be immediately... or for whot i`m using "with nowait"
option ???
What wrong???
The pice of client code:
Dim cmd
Dim e
Set cmd = CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
cmd.CommandText = "habibi_ac_test1"
cmd.CommandType = 4
Set rs = cmd.execute(, , adAsyncExecute)
CREATE proc habibi_ac_test
as
raiserror('Some message...',16,1) with nowait
WAITFOR DELAY '00:00:10'
select top 5 * from documents
GO
The client program use ADO to access data.
My client application raises error only after 10 seconds...
I think it will be immediately... or for whot i`m using "with nowait"
option ???
What wrong???
The pice of client code:
Dim cmd
Dim e
Set cmd = CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
cmd.CommandText = "habibi_ac_test1"
cmd.CommandType = 4
Set rs = cmd.execute(, , adAsyncExecute)