BCS Executable Cross Reference

To access and document Delphi projects working in reverse order is sensible.  The applications allows you to select the executable modules of a specific sub directory.  From this application practically all required programmer activity is attainable for subsequent application development and documentation.

This view reveals many of the Primary Options available.

rex14

When the Load Executable option is selected the following dialog will appear.

rex15

Select the desired directory and click on the Select Folder option.

To gain complete access to this tool software produced by Brooks Computing Systems, LLC and other vendors must be installed and present within your configuration.  There is no charge for any of these tools.

rex02

Notice the selected sub directory is listed and centered at the top of the dialog.

The dialog below identifies the options available to the user after the executable has been selected by double clicking on any file specification in the list control.

rex01

The Execute option launches the executable as is.  This option allows the user to execute the program.  Notice the 32 and 64 bit executables are available for subsequent execution.

The Search option allow the user to specify a search string to detect in the list of files.

rex03

When the user selects the search string by clicking on the Ok control all file specification that contain that text are highlighted.

The Compile option dynamically creates the project path from the executable file specification and launches the Delphi IDE for subsequent application development.

The View option populates the Project File List tab with the file specifications for the project.

rex04

Notice the directory for the Delphi project appears centered at the top of the dialog.  When the user double clicks on any item in the list the following dialog will appear.

rex05

When you double click on the Execute option the associated file is launched immediately.  If the file you selected is a Delphi project file the Delphi IDE is launched.  If the file specification is an executable file the application begins its execution.

When you double click on the View option the file specification is available for viewing in the File Viewer Tab of the application.

The Position By Path option lists a unique paths for the subject directory.  The dialog appears below.

rex06

When the user double clicks on the list control the user is automatically positioned in the Executable Programs Workbench tab.  This feature is most useful with there are many sub folders because it allows rapid traversal of the list and double clicking selects the desired object.

When the Document This One option is selected the user is positioned to the Documentation Center tab of the application.  This location is listed in the dialog below.

rex07

Initially the file specification is populated for you and you simply add a descriptive title and the associated narrative in the Basic Information tab.  Click on the Maintenance Log to gain access to the maintenance details.

rex08

Invoke the popup menu for the Maintenance Log tab and the options appear.  If you click on the Copy Mod Log To Clipboard the Maintenance log in its entirety is copied to the clipboard for subsequent pasting (into Code Centeral or other locations) that can accommodate plain old text (pot).

When the user selects the Add New Line menu item the user is prompted for the new entry description.  The application supplies the time stamp and formatting.

rex09

When the user clicks the Ok control the new maintenance line is inserted.

There is a Future Maintenance tab is where we can make entries for future modifications for each application.

rex16

The Add Future Item menu item will invoke a dialog to identify the future actions.

rex17

Tap the OK button to insert the designated description into the Future Maintenance items area.

To move a Future Maintenance Item over the to Maintenance Log highlight a single item then invoke the popup menu and select the Add To Maintenance option.  The highlighted item is remove from the Future Maintenance tab and added to the Maintenance Log.

rex18

The Sort Descending Sequence reversed the order of the items in the list so the last item becomes the first item.

There is a report available for the Maintenance Log which is depicted below.

rex13

When the user selects the Zip This Directory option the user is prompted to authorize the creation of the zip file.

rex10

When the user selects the Add To Executable Base this executable is added to the list of executables used by the programmer’s workbench.  This feature provides a simple mechanism to invoke the executable by using its record number for its selection.

rex11

If the item selected is already in the database the above dialog appears and the process continues as you would normally expect.

If the item is not already in the database the following dialog appears prompting the user for the program description.

rex12

Subsequently the appropriate record is inserted into the database and is available for immediate use.

Below is the database schema used for this application.

-- phpMyAdmin SQL Dump
-- version 4.6.0
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 22, 2016 at 04:29 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: `bcsra`
--
 
-- --------------------------------------------------------
 
--
-- Table structure for table `ext`
--
 
CREATE TABLE `ext` (
  `id` int(11) NOT NULL,
  `ext` varchar(75) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `lud`
--
 
CREATE TABLE `lud` (
  `id` int(11) NOT NULL,
  `rdate` datetime NOT NULL,
  `sdes` varchar(125) NOT NULL,
  `sdir` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `sdoc`
--
 
CREATE TABLE `sdoc` (
  `id` int(11) NOT NULL,
  `sdes` varchar(125) NOT NULL,
  `sdir` varchar(255) NOT NULL,
  `doc` mediumtext NOT NULL,
  `maint` mediumtext NOT NULL,
  `fut` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--
-- Indexes for dumped tables
--
 
--
-- Indexes for table `ext`
--
ALTER TABLE `ext`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ext` (`ext`);
 
--
-- Indexes for table `lud`
--
ALTER TABLE `lud`
  ADD PRIMARY KEY (`id`);
 
--
-- Indexes for table `sdoc`
--
ALTER TABLE `sdoc`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sdir` (`sdir`);
 
--
-- AUTO_INCREMENT for dumped tables
--
 
--
-- AUTO_INCREMENT for table `ext`
--
ALTER TABLE `ext`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lud`
--
ALTER TABLE `lud`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=243;
--
-- AUTO_INCREMENT for table `sdoc`
--
ALTER TABLE `sdoc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
/*!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 */;

 

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.