SQLiteDatabase.Timeout

From Xojo Documentation

Property (As Double )
aSQLiteDatabase.Timeout = newDoubleValue
or
DoubleValue = aSQLiteDatabase.Timeout

Supported for all project types and targets.

The maximum number of seconds that an operation may wait before a lock is cleared (if any). The default is 10.

Notes

If an operation has to wait longer than this amount of seconds then the operation will fail (with a suitable SQL error).

If the value is less than or equal to 0 then all busy handlers will be disabled and the operation will wait indefinitely.

This value can be changed at any time.

Example

This example sets the Timeout to 30 seconds.

Dim dbFile As GetFolderItem("MyDB.sqlite")

Dim db As New SQLiteDatabase
db.DatabaseFile = dbFile

db.Timeout = 30

If db.Connect Then
// Key was correct; DB is connected
MsgBox("Connected to database.")
Else
MsgBox("Connection error: " + db.ErrorMessage)
End If