For each application offered a maintenance log is require for future modifications. This application provides all the necessary communications to create and maintain the update log.
When a new record is requested a select file dialog appears requesting the project file for the maintenance log.
Once the file is selected the maintenance log is dynamically created in the Modifications Log tab and is ready for subsequent updates.
A popup feature allow the user to update the maintenance log while another options copies the maintenance log to the clipboard for subsequent pasting in the blog article or Embarcadero Code Central.
This utility makes it fairly painless to maintain update logs for blogs and Code Central.
There are two types of reports for this utility. The first report prints a single log. The other report prints all the logs in the database.
The SQL to create the table can be viewed below.
[codesyntax lang=”sql”]
-- phpMyAdmin SQL Dump -- version 4.3.7 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 15, 2015 at 12:16 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 utf8 */; -- -- Database: `delphi_mods` -- -- -------------------------------------------------------- -- -- Table structure for table `dmods` -- CREATE TABLE IF NOT EXISTS `dmods` ( `id` int(11) NOT NULL, `fs` varchar(500) NOT NULL, `mods` mediumtext NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `dmods` -- ALTER TABLE `dmods` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `fs` (`fs`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `dmods` -- ALTER TABLE `dmods` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10; /*!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]
The component documentation for this utility can be viewed here.
The source code for this utility can be accessed by clicking here.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.