ADO SQLState egenskap

Definition och användning

SQLState egenskapen returnerar en sträng som innehåller de fem tecken lång SQL-felkoden som returneras av tillhandahållaren.

Syntax

strErrorSQL=objErr.SQLState

Exempel

<%
for each objErr in objConn.Errors
  response.write("<p>")
  response.write("Beskrivning: ")
  response.write(objErr.Description & "<br />")
  response.write("Hjälpp kontext: ")
  response.write(objErr.HelpContext & "<br />")
  response.write("Hjälpp fil: ")
  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
%>