There are a certain set of tools programmers utilize to accomplish programming tasks. Capabilities to position the database (master and detail) to a desired location exists. To view this option press the popup chord and the popup menu will appear.
This task is primarily accomplished by using a master detail scenario that established categories. Then the details for each category are established.
The detail view appears below.
When the programmer double clicks on the item in the grid the associated application is launched. The Shell API is leveraged to all the Windows associations are in play at this point. As an example if the file specification ends in a “.pdf” the associated PDF Application is invoked with the file name as input.
A full File Manager is included on the final tab on the main view.
Many handy features such as directory level and file level functions to create, rename, copy, move and delete respective folders and file specifications. The 7 Zip interface has been pressed into place when compression extraction needs to be performed.
When a file is selected and the popup menu is activated the following dialog is viewed.
When the user selects the file statistics option the following menu will appear.
The user has some information about the file’s specification.
A web browser is included for documenting web content using the same scenario.
The Web Browser tab reveals the active Web Browser. The last control below the menu copies the url and the web page title and inserts it into the database. That way the programmer has no requirement to cut and paste anything.
The master table SQL is below.
[codesyntax lang=”sql”]
-- phpMyAdmin SQL Dump -- version 4.3.7 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 21, 2015 at 03:32 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: `bcswebtools` -- -- -------------------------------------------------------- -- -- Table structure for table `lk1` -- CREATE TABLE IF NOT EXISTS `lk1` ( `idlk1` int(11) NOT NULL, `cat` varchar(75) NOT NULL, `ddes` mediumtext NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `lk1` -- ALTER TABLE `lk1` ADD PRIMARY KEY (`idlk1`), ADD UNIQUE KEY `cat` (`cat`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `lk1` -- ALTER TABLE `lk1` MODIFY `idlk1` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=75; /*!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 detail table SQL is below.
[codesyntax lang=”sql”]
-- phpMyAdmin SQL Dump -- version 4.3.7 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 21, 2015 at 03:32 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: `bcswebtools` -- -- -------------------------------------------------------- -- -- Table structure for table `lk2` -- CREATE TABLE IF NOT EXISTS `lk2` ( `idlk2` int(11) NOT NULL, `idlk1` int(11) NOT NULL, `lkn` varchar(125) DEFAULT NULL, `lnk` varchar(125) DEFAULT NULL, `ddes` mediumtext NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=499 DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `lk2` -- ALTER TABLE `lk2` ADD PRIMARY KEY (`idlk2`), ADD UNIQUE KEY `lkn` (`lkn`), ADD KEY `idlk1` (`idlk1`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `lk2` -- ALTER TABLE `lk2` MODIFY `idlk2` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=499; -- -- Constraints for dumped tables -- -- -- Constraints for table `lk2` -- ALTER TABLE `lk2` ADD CONSTRAINT `idlk1` FOREIGN KEY (`idlk1`) REFERENCES `lk1` (`idlk1`); /*!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 can be viewed by clicking here.
The source code for this application can be accessed by clicking here.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.