This tool allows the end user to edit any existing MySQL data table.
A database grid supports rapid navigation to a specific location in the database while simultaneously allowing a data entry panel for modifying any data element. Several of the previously existing tools that performs various functions are utilized in this application. The BCS Forms Repository (no dfm) was employed to populate this project with the required components.
The tool allows the user to select the table from a list of all available tables.
Once the table is selected by double clicking on the desired item the following dialog will appear. Now the user is prompted to select the data element which will be use as the table’s index.
Double click on the desired item and the following dialog will appear.
Here the user selects the data elements that will appear in the database grid.
Notice when you click on the Data Entry tab you are able to modify the default attributes for the database grid element.
You may change the data elements width and display title or make the grid field read only. For all primary keys you intend to display change the “ro” attribute to true by clicking on the checkbox and making the true selection appear.
When you exit the grid element selection dialog the following data entry dialog will appear. Again the grid view allows for rapid navigation of the data table.
When the Data Entry tab is selected you have a form which allows the modification or deletion of existing data while you also have the capability to insert new records.
When the are finished with the data edit module the following message appears.
When you are done editing table click the “No” option and the application terminates. To continue to edit data tables click the “Yes” option and the process re initializes for reuse.
A 32 bit executable program may be downloaded by clicking here.
A 64 bit executable program may be downloaded by clicking here.
The component documentation can be found by clicking here.
The source code may be found by clicking here.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.