ADO SQLState 屬性
❮ 完整的 Error 物件參考
SQLState 屬性返回一個字串,其中包含提供程式返回的 5 個字元的 SQL 錯誤程式碼。
語法
strErrorSQL=objErr.SQLState
示例
<%
for each objErr in objConn.Errors
response.write("<p>")
response.write("描述: ")
response.write(objErr.Description & "<br>")
response.write("幫助上下文: ")
response.write(objErr.HelpContext & "<br>")
response.write("幫助檔案: ")
response.write(objErr.HelpFile & "<br>")
response.write("原生錯誤: ")
response.write(objErr.NativeError & "<br>")
response.write("錯誤號: ")
response.write(objErr.Number & "<br>")
response.write("錯誤源: ")
response.write(objErr.Source & "<br>")
response.write("SQL 狀態: ")
response.write(objErr.SQLState & "<br>")
response.write("</p>")
next
%>
❮ 完整的 Error 物件參考