Table of Contents

TTMSFNCKanbanBoardDatabaseAdapter Class

Database adapter that binds a kanban board to a dataset, mapping dataset fields to item properties and synchronising inserts, updates, deletions, and selection with the underlying data source.

API unit family: TMSFNCKanbanBoardDatabaseAdapter Inherits from: TTMSFNCKanbanBoardAdapter

Syntax

TTMSFNCKanbanBoardDatabaseAdapter = class(TTMSFNCKanbanBoardAdapter)

Properties

Name Description
Item Describes the dataset field mappings used to read and write kanban board item data.
Version Version string of the database adapter component.

Methods

Name Description
AfterUpdateItem Called after an item update has been posted; performs any required post-update housekeeping.
DeleteItem Locates and deletes the dataset record that corresponds to the specified kanban board item.
GetItems Reads all records from the dataset and populates the kanban board columns with the corresponding items.
InsertItem Appends a new record to the dataset for the specified kanban board item and writes its field values.
LoadItems Clears the current kanban board items and reloads all records from the dataset.
ReadItem Reads the dataset record that corresponds to the specified kanban board item and updates the item's properties.
SelectItem Scrolls the dataset to the record that corresponds to the specified kanban board item.
UpdateItem Locates the dataset record for the specified kanban board item and writes its current property values back to the dataset fields.

Events

Name Description
OnColumnToFields Occurs when a kanban board column index is about to be written to the dataset, allowing custom mapping from the column index to dataset fields.
OnFieldsToColumn Occurs when a dataset record is read and the adapter needs to determine which kanban column the item belongs to; handle this event to provide custom column resolution.
OnFieldsToItem Occurs when dataset fields are being read into a kanban board item, allowing custom field mapping from the dataset to the item.
OnItemCreateDBKey Occurs when a new item is inserted and the adapter needs a unique key value; handle this event to supply a custom key instead of using the auto-generated one.
OnItemInserted Occurs after a new item has been inserted into the dataset.
OnItemLocate Occurs when the adapter needs to locate a specific dataset record for a kanban board item; handle this event to provide a custom locate strategy.
OnItemRead Occurs after a kanban board item has been read from the dataset.
OnItemToFields Occurs when an item is about to be written to the dataset, allowing custom field mapping from the kanban board item to dataset fields.
OnItemUpdated Occurs after a kanban board item's changes have been posted to the dataset.
OnItemsLoaded Occurs after all items have been loaded from the dataset into the kanban board.