locked
get raiserror info in JScript RRS feed

  • Question

  • Hello everyone,


    I hava some problem to get raiserror in JScript.

    JScript code:
    try{
        cmd.execute();
        WScript.echo(conn.errors.count);
    }
    catch(e){
        if(conn.errors.count>0){
            //get the raiserror info and display
        }
    }

    in stored procedures:
    select ‘3’
    RAISERROR ('CurveSetID %d does not exist', 16, 1,@CurveSetID)
    return -1

    Why can't  I get the RAISERROR info in JS code, and the conn.errors.count is 0.

    if i delete ' select '3' ', it's ok to get the raiserror info. Why?

    How can I get the raiserror info in the JScript with using raiserror after select statement?

    Thx~~~

    Friday, July 10, 2009 3:15 AM