BCS Executable Program Utility


There are those times when is is reasonable to invoke a stand alone executable file.  The BCS Executable Program Utility manages the idiosyncrasies of executable stand alone programs.
xqtres
To use this feature just place the source code subsequent to any existing application that desires to employ there executable functions.  Then add this form to your application and you are all set.
Use this form in show modal fashion to add or modify existing executable information.
A report is available that allows the user to quickly review what is in the repository.
xqtrep
The SQL for creating the table is listed below.
[codesyntax lang=”sql”]

-- 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 */;

[/codesyntax]
The component documentation can be reviewed by clicking here.
The applications source code can be obtained by clicking here.
Please feel free to comment or make suggestions on this article in the comments section below.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

Leave a Reply

Your email address will not be published. Required fields are marked *