ADO - foutvoorwerp


Foutvoorwerp

Die ADO-foutvoorwerp bevat besonderhede oor datatoegangsfoute wat tydens 'n enkele bewerking gegenereer is. 

ADO genereer een Fout-objek vir elke fout. Elke Fout-objek bevat besonderhede van die spesifieke fout, en word in die Foutversameling gestoor. Om toegang tot die foute te verkry, moet jy na 'n spesifieke verbinding verwys.

Om deur die foutversameling te loop:

<%
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

Eienskappe

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