DatabaseColumn.Name

From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

Read-Only Property (As String )
StringValue = aDatabaseColumn.Name

New in 2019r2

Supported for all project types and targets.

Used to get the name of the column.

Sample Code

The following method populates a DesktopListBox with a RowSet. It uses the Name and StringValue properties to obtain the columnnames and values:

Sub PopulateListBox(dataList As DesktopListBox, rs As RowSet)
If rs Is Nil Then Return

// set up listbox state for population
dataList.RemoveAllRows

// Add the DB columns as the heades for the ListBox
dataList.ColumnCount = rs.ColumnCount
dataList.ColumnAttriutesAt(-1).WidthExpression = "100"
For i As Integer = 0 To rs.ColumnCount - 1
dataList.HeaderAt(i) = rs.ColumnAt(i + 1).Name
Next

// Add the data from the table
While Not rs.AfterLastRow
dataList.AddRow("")

For i As Integer = 0 To rs.LastColumnIndex
dataList.CellTextAt(dataList.LastAddedRowIndex, i) = rs.ColumnAt(i + 1).StringValue
Next

rs.MoveToNextRow
Wend
End Sub