Sofar I have come across 2 bugs in this control.
When doing a column sort (lvw.SortColumn and also lvw.TableSort) the background colour of the control disappears. Resetting it after the sort doesn't help.
Secondly, setting the column widths in AddColumn doesn't behave as expected in that setting the value -1 (to autofit) doesn't work and gives very narrow columns.
Not a bug, but it is also quite a bit slower than the simple Table control, particularly on populating the control. This is when doing:
Reader.Value = cmd.ExecuteReader
Do While Reader.ReadNextRow = True
For c = 0 To UB
arrLVWRow(c) = Reader.GetValue(c)
Next
lvw.AddRow(arrLVWRow())
lRecords = lRecords + 1
Loop
And maybe I should use lvw.LoadSQL but that means I have to make a temp
SQLite table first.
RBS
When doing a column sort (lvw.SortColumn and also lvw.TableSort) the background colour of the control disappears. Resetting it after the sort doesn't help.
Secondly, setting the column widths in AddColumn doesn't behave as expected in that setting the value -1 (to autofit) doesn't work and gives very narrow columns.
Not a bug, but it is also quite a bit slower than the simple Table control, particularly on populating the control. This is when doing:
Reader.Value = cmd.ExecuteReader
Do While Reader.ReadNextRow = True
For c = 0 To UB
arrLVWRow(c) = Reader.GetValue(c)
Next
lvw.AddRow(arrLVWRow())
lRecords = lRecords + 1
Loop
And maybe I should use lvw.LoadSQL but that means I have to make a temp
SQLite table first.
RBS