This application allows the user to populate the MySQL data element display label. To begin the process click on the Select Data Table option.
The following dialog will appear. Simply traverse the list and double click on the desired data table.
The list of the available data elements appear in the following dialog. For new data elements not found in the repository and new entry is made simultaneously. The repository is designed for unique data elements names only. For our purposes duplicate data names are not allowed.
Click on the desired data element to invoke the edit dialog.
Only the Label Field in this dialog may be modified. All other fields are read only. This process may be repeated until you are satisfied the the data element labels for you tables reflects the correct label information.
The repository is listed below.
[codesyntax lang=”mysql”]
-- phpMyAdmin SQL Dump -- version 4.6.4 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Sep 30, 2016 at 03:09 AM -- Server version: 5.6.17 -- PHP Version: 5.5.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `de` -- -- -------------------------------------------------------- -- -- Table structure for table `dl` -- CREATE TABLE `dl` ( `id` int(11) NOT NULL, `dna` varchar(75) NOT NULL, `lab` varchar(125) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `dl` -- ALTER TABLE `dl` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `dna` (`dna`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `dl` -- ALTER TABLE `dl` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
[/codesyntax]
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.