Records and data binding

A loaded result, an editable draft and committed database state are different things.

Read the task-based guide before using an isolated signature. Arguments are positional unless a signature explicitly marks an optional argument.

Recordset#

Rows and columns use zero-based positions. A provider page does not contain every database row.

BASIC-facing contract

RowCount, ColumnCount, PageIndex, PageSize As Long (read only)
IsProviderPage, HasMore As Boolean (read only)
Function Value(rowIndex As Long, columnName As String) As Variant
Function ColumnName(index As Long) As String
Function Rows(index As Long) As DbRow
Function Columns(index As Long) As DbColumn
Function Bind() As BindingSource
Async Sub ExportCsvAsync(path As String)

DbRow / DbColumn#

Use the row/column objects returned by the Recordset.

BASIC-facing contract

DbRow: Function Value(columnName As String) As Variant
DbColumn: Name As String (read only)

BindingSource state#

Inspect the loaded draft and its validation result.

BASIC-facing contract

RowCount, PageIndex, PageSize As Long (read only)
Dirty, IsProviderPage, HasMore As Boolean (read only)
ValidationError As String (read only)
Function Value(rowIndex As Long, columnName As String) As Variant

BindingSource editing#

Draft editing alone does not write SQLite. Validate and explicitly save, or cancel the draft.

BASIC-facing contract

Sub BeginEdit()
Sub SetValue(rowIndex As Long, columnName As String, value As Variant)
Sub SetText(rowIndex As Long, columnName As String, text As String)
Function AddNew() As Long
Sub Delete(rowIndex As Long)
Sub Require(columnName As String)
Function Validate() As Boolean
Sub CancelEdit()
Sub Refresh()
Async Function SaveAsync(database As Database, tableName As String, keyColumn As String) As Long

Source baseline 20f4bfed6b · Build manifest