with nowait option in raiserror
From: habibi (smotrov2000_at_mail.ru)
Date: 06/15/04
- Next message: Dariusz Jankowski: "How to interpret CASES in Microsft Clustering Alg"
- Previous message: Adam Machanic: "Re: run sp and return results to .asp"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Jun 2004 13:52:18 +0300
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)
-- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
- Next message: Dariusz Jankowski: "How to interpret CASES in Microsft Clustering Alg"
- Previous message: Adam Machanic: "Re: run sp and return results to .asp"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
