ADO SQLState Attribute

Definition and Usage

Ang SQLState na katangian ay maaaring ibalik ang isang string na naglalaman ng limang karakter na SQL error code na ibinabalik ng provider.

Grammar

strErrorSQL=objErr.SQLState

Sample

<%
for each objErr in objConn.Errors
  response.write("<p>")
  response.write("Paglalarawan:")
  response.write(objErr.Description & "<br />")
  response.write("Context ng tulong:")
  response.write(objErr.HelpContext & "<br />")
  response.write("Tulong na 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
%>