Objek Kesalahan ADO
Objek Kesalahan
Objek Kesalahan ADO berisi rincian tentang kesalahan akses data yang telah dihasilkan selama operasi tunggal.
ADO menghasilkan satu objek Kesalahan untuk setiap kesalahan. Setiap objek Error berisi detail error tertentu, dan disimpan dalam koleksi Errors. Untuk mengakses kesalahan, Anda harus merujuk ke koneksi tertentu.
Untuk mengulang koleksi Errors:
<%
for each objErr in objConn.Errors
response.write("<p>")
response.write("Description: ")
response.write(objErr.Description & "<br>")
response.write("Help context: ")
response.write(objErr.HelpContext & "<br>")
response.write("Help file: ")
response.write(objErr.HelpFile & "<br>")
response.write("Native error: ")
response.write(objErr.NativeError & "<br>")
response.write("Error number: ")
response.write(objErr.Number & "<br>")
response.write("Error source: ")
response.write(objErr.Source & "<br>")
response.write("SQL state: ")
response.write(objErr.SQLState & "<br>")
response.write("</p>")
next
%>
Sintaksis
objErr.property
Properti
Property | Description |
---|---|
Description | Returns an error description |
HelpContext | Returns the context ID of a topic in the Microsoft Windows help system |
HelpFile | Returns the full path of the help file in the Microsoft Windows help system |
NativeError | Returns an error code from the provider or the data source |
Number | Returns a unique number that identifies the error |
Source | Returns the name of the object or application that generated the error |
SQLState | Returns a 5-character SQL error code |