Xojo Documentation Xojo Documentation

Property (As Boolean )

aSQLiteDatabase.ShortColumnNames = newBooleanValue
or
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.

Example

This example disable short column names:

Var dbFile As New FolderItem("MyDB.sqlite")

Var db As New SQLiteDatabase
db.DatabaseFile = dbFile

db.ShortColumnNames = False

Try
db.Connect
// Key was correct; DB is connected
MessageBox("Connected to database.")
Catch error As DatabaseException
MessageBox("Connection error: " + error.Message)
End Try