Go to Examples > Databases > DBKit - Current Beta to download it.
DBKit 2.1 Beta 3 Release Notes
New
- A DBKit.Table column can now be displayed as a checkbox by setting the column’s entry in ColumnFormats to CheckBox. A value of 0 or an empty string displays as unchecked; any other value displays as checked. Whether the user can toggle the checkbox is still governed by EditableColumnNames, and a toggle writes the value back in the form the column already uses, so a text column keeps its own values rather than gaining “True” and “False”.
- A DBKit.Table column can now be displayed as a progress bar by setting the column’s entry in ColumnFormats to ProgressBar. A bare entry treats the value as falling between 0 and 100; ProgressBar(minimum:maximum) names a custom range. An editable progress bar column still edits as text.
- A DBKit.Table column can now be displayed as a currency amount by setting the column’s entry in ColumnFormats to Currency, instead of providing a format string. A bare entry uses the operating system’s currency (in web projects, the server’s). Colon-separated parameters, which can be given in any order, name an ISO currency code, the symbol to display, and the number of decimal places; the symbol’s position in the list sets whether it appears before or after the amount, so Currency(¥:JPY) displays the symbol first and Currency(JPY:¥) displays it last. Anything not specified comes from the currency’s standard symbol and decimal places, or from the operating system.
- A DBKit.Table column can now be displayed as a percentage by setting the column’s entry in ColumnFormats to Percentage. The value in the database is a fraction: 1 displays as 100% and 0.1 displays as 10%. A bare entry shows up to two decimal places, dropping trailing zeros; Percentage(2) always shows two.
Bug Fixes
- Fixed a stack overflow exception that occurred when a control’s RowChanged event handler changed the value of the column the control is bound to, using the DBKit.Row passed to the handler. The handler’s change fed back into the control and then into the row again, endlessly.
- Fixed DBKit.TextArea not becoming editable when its layout was in edit mode, in both desktop and web projects.
Known Issues
- Opening a DBKit.Page containing a DBKit.ImageViewer may occasionally freeze for up to a minute before the data appears. The freeze is associated with the ImageViewer control: so far it has only been seen on DBKit.Pages using MySQL and PostgreSQL, and infrequently. DBKit.Pages without an ImageViewer are not affected. We are still looking into it.