Database.Error

From Xojo Documentation

Revision as of 21:11, 23 January 2019 by PLefebvre (talk | contribs)

(diff) ← Older revision | Approved revision (diff) | Latest revision (diff) | Newer revision → (diff)
Read-Only Property (As Boolean )
BooleanValue = aDatabase.Error

Supported for all project types and targets.

True if an error is returned from the database engine. See the values of the ErrorCode and ErrorMessage properties to learn the specifics of the error.

Notes

You should check the Error property after each database operation to see if there was an error. If there is an error, you can display or log the ErrorCode and ErrorMessage.

Sample Code

This code attempts to create an in-memory SQLite database and displays the error if one occurred:

Dim db As New SQLiteDatabase
If db.Connect Then
// Connected to in-memory database
Else
If db.Error Then
MsgBox("Error: " + Str(db.ErrorCode) + " - " + db.ErrorMessage)
End If
End If