判断sql执行成功,sql执行,sql执行结果

利用ERR对象:



    SQL="INSERT INTO TABLE(F1,F2) VALUES('V1','V2')"

    CONN.EXECUTE SQL

    IF ERR.NUMBER<>0 THEN

        RESPONSE.WRITE "出错了:"& ERR.DESCRIPTION ERR.CLEAR

    ELSE

        RESPONSE.WRITE "OK"

    END IF