如何检测与处理执行SQL语句后的错误

[efis]

如果执行一个插入语句,而关键字与已经存在的记录冲突,或删除记录,却因有外键约束关系,不能删除,这时浏览器中显示错误信息,但我希望可以定制这个信息,就是说需要获取错误值,不知道怎么做?

[gshope]

set myerror=conn.errors
...

[gshope]

set myerror=conn.errors
...

[swingcoder]

error.desc

[efis]

我用的是UltraDEV 40,它的代码如下:没有建立connection对象

set MM_rsUser = Server.CreateObject(MM_flag)
MM_rsUser.ActiveConnection = MM_proman_STRING
MM_rsUser.Source = "SELECT strUserName, strPassword"
If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
MM_rsUser.Source = MM_rsUser.Source & " FROM tbluser WHERE strUserName='" & MM_valUsername &"' AND strPassword='" & CStr(Request.Form("password")) & "'"
MM_rsUser.CursorType = 0
MM_rsUser.CursorLocation = 2
MM_rsUser.LockType = 3
MM_rsUser.Open