connection object and sql stored procedures (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 02 APR 1998 03:52:14PM pedro azpurua wrote:

OpenInsight Specific

Dear cameron:

when working with stored procedures in ms sql server 6.5

the connection object works fine until i introduce RAISEERROR in the sp.

The query method EXECUTE fails to work. I dont know if that is is correct. I can live with this but the worst problem is that when i try to execute another query it says i receive a message saying that there is information pending. (I have CANCEL the query)

Any idea of what is happening?

Yours Pedro Azpurua

opentechnology

(looking forward to hear fron the jrev roundtable)

Thanks

At 03 APR 1998 02:45PM DSig (SigSolutions) wrote:

Pedro,

When you execute the "CANCEL" what is the result? I have found at times that the Cancel does not return TRUE so I then must DESTROY the qryhandle.

dsig

David Tod Sigafoos ~ SigSOlutions

dsig@teleport.com cis:70302,77 voice:503-639-8080

At 03 APR 1998 05:54PM pazpurua wrote:

I suppose that you are asking when I am using an sql stored procedure. The answer is yes I get a 1 even althoug there was a failure in the EXECUTE.

ppa

View this thread on the forum...