Current version: 0.1.63
Available from:  This Link
License:         GPL
Author:          Gareth Bult (Encryptec Limited)

Requirements

• Gambas 1.9.48
  
• MySQL 5+
  

Description

DBConnection is designed as a design time wrapper for a connection object.

GridEditor is an enhanced GridView component with in-line editing facilities

DBGridEditor is a sub-class of GridEditor with SQL DB handling

(shown to the right are three DBGridEditors linked in Master-slave mode)

Features (as shown);

• Changes are "marked" until you "commit" the table
• Row deletions are in red (toolbar button or "Del") with a red cross icon
• Row insertions are marked with a "+" Icon
• Rows with changes are marked with the scisors icon
• Actual changes are marked as red on white
• Different fields have different editor types, current textedit, combo or textarea (checkbox coming soon)
• Cursor keys give spreadsheet effect. enter or space or double click gives appropriate editor
• Buttons shown are "defaults" and auto-linked to the editor
• Properties include fields containing columns to display, titles, column widths etc
• Properties also include appropriate SELECT,DELETE,UPDATE and INSERT commands
• Sample shows an edit session of my DNS zone file (which supplies live DNS via Bind9 + DLZ patches
• Note that in-line changes (add/edit/delete) do not require complete refreshes, hence the in-line markup
• Save or cancel commits or rolls back changes clearing all on-screen markup
• In-line Sorting now available with sort indicators on column headings .. no sort, single column and multi-column all available and all supported in-line by DBGridEditor with no additional coding to convert existing programs.
  

Todo

• Add dynamic Filter
  
• Byline in the toolbar showing the current record count
• Property to turn the toolbar on/off