From Xojo Documentation

Property (As Boolean )
aSQLiteDatabase.ShortColumnNames = newBooleanValue
BooleanValue = aSQLiteDatabase.ShortColumnNames

Supported for all project types and targets.

If True, the column names as they appear in table schemas for query results are used whenever possible. Aliased columns and ambiguous columns will be fully qualified.

If False, the column names are used exactly as they appeared in the original query. The default value is True.


This example disable short column names:

Dim dbFile As GetFolderItem("MyDB.sqlite")

Dim db As New SQLiteDatabase
db.DatabaseFile = dbFile

db.ShortColumnNames = False

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