Sub LoadBirthdayRecords
clvPersons.Clear
Dim sCurrentMonthYear As String
Dim data As DataSet
Dim rs As ResultSet
rs = oSQL.ExecQuery("SELECT * FROM tblData ORDER BY BirthDate DESC")
Do While rs.NextRow
data.ID = rs.GetInt("ID")
data.FirstName = rs.GetString("FirstName")
data.LastName = rs.GetString("LastName")
data.BirthDate = rs.GetLong("BirthDate")
Dim sTempMonthYear As String = GetMonthYear(data.BirthDate)
If sTempMonthYear <> sCurrentMonthYear Then
'we are passing recID as return value
clvPersons.Add(CreateGroupHeaderRow(data.BirthDate, clvPersons.AsView.Width), data.ID)
sCurrentMonthYear = sTempMonthYear
'we are passing recID as return value
clvPersons.Add(CreatePersonRow(data, clvPersons.AsView.Width), data.ID)
Else
'we are passing recID as return value
clvPersons.Add(CreatePersonRow(data, clvPersons.AsView.Width), data.ID)
End If
Loop
rs.Close
For i = 0 To clvPersons.Size - 1
Dim p As B4XView = clvPersons.GetPanel(i)
If p.Tag = "GroupHeader" Then
p.Parent.Enabled = False
End If
Next
'XUIViewsUtils.AddStubToCLVIfNeeded(clvPersons, xui.Color_White)
clvPersons.ScrollToItem(1)
End Sub