BCS Master Detail Infomation Collector

To collect information to be subsequently used in a master detail scenario the BCSMDInfo component fulfills that requirement.

BCSMD01

Once the component has executed successfully the following information is returned.

BCSMD02

As you can see all the information to establish the master detail scenario is collected.

Component documentation can be located http://archbrooks.com/compdoc/BCSMDInfo/html/BCS%20Collect%20Master%20Detail%20Information.htm.

The source code for this tool is located at http://cc.embarcadero.com/item/29690.

A modification was added to collect database user login credentials.  The Universal User Login component was used for this feature.  The article for the utility can be found at http://bcsjava.com/blg/wordpress/post.php?post=903.

A new table was created to support this level of user verification.  It schema is listed below.

-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 17, 2014 at 01:17 PM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.26
 
51&q=SET&lr=lang_en">SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
51&q=SET&lr=lang_en">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 `dbct`
--
 
51&q=CREATE&lr=lang_en">CREATE 51&q=TABLE&lr=lang_en">TABLE 51&q=IF%20NOT%20EXISTS&lr=lang_en">IF 5.1/en/non-typed-operators.html">NOT EXISTS `dbct` (
  `id` 51&q=INT&lr=lang_en">int(11) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL 51&q=AUTO_INCREMENT&lr=lang_en">AUTO_INCREMENT,
  `uid` 51&q=VARCHAR&lr=lang_en">varchar(25) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL,
  `pwd` 51&q=VARCHAR&lr=lang_en">varchar(25) 5.1/en/non-typed-operators.html">NOT 51&q=NULL&lr=lang_en">NULL,
  51&q=PRIMARY%20KEY&lr=lang_en">PRIMARY KEY (`id`)
) 51&q=ENGINE&lr=lang_en">ENGINE=51&q=INNODB&lr=lang_en">InnoDB 51&q=DEFAULT&lr=lang_en">DEFAULT 51&q=CHARSET&lr=lang_en">CHARSET=utf8 51&q=AUTO_INCREMENT&lr=lang_en">AUTO_INCREMENT=1 ;
 
/*!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 */;

This table contains a user name and a password value for verification purposes.

Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.

Leave a Reply