BCS Delphi XE8 Source Code Generator via MySQL

The new and improved BCS Delphi XE8 Source Code generator has just arrived.  The newest version employs MySQL table blobs in lieu of static flat files.

mcg01

  • Primary Options

    Generators

    The generators will all display the following dialog as input is required from the end user.

    mcg06

    When the user taps the OK control the following prompt is issued.

    mcg07

    When the user taps the Ok button again the following dialog appears.

    mcg08

    Now when the OK button ton the message dialog is clicked the following dialog appears.

    mcg09

    As soon as the target directory is selected the populated dialog appears as indicated below.

    mcg10

    Remember this sequence is repeated for each code generation request.
    The user will receive a primary form and application that can execute stand alone, a component wrapper and a component tester. Of course the component wrapper installs the component while the component tester will test or execute installed components.

      • VCL 01 No Data No Styles
        The following depicts the output of the code that was generated.
        mcg11
      • VCL 02 One Table No Styles
        mcg12
        The Show Unique Alias dialog appears first. This dialog speeds up the data table selection process and the number of data tables increase.  The user is not required to scroll from the top or the list down to the desired location.  By positioning with the unique alias the scrolling is not required.mcg13
        The next dialog positions the user at the top of the table list based on the unique alias selected.
        mcg14
      • VCL 03 Master Detail No Styles
        The Show Unique Alias dialog appears first. This dialog speeds up the data table selection process and the number of data tables increase.
        mcg13
        The next dialog positions the user at the top of the table list based on the unique alias selected.
        mcg15
        Notice the alias list on the left and right. The left side depicts the master data set while the right list of alias’s depict the details data set.
        mcg16
      • VCL 04 No Data w Styles
        This is the output from invoking option “VCL 04 No Data w Styles”.
        mcg17
      • VCL 05 One Table w Styles
      • The user is prompted for the data in the same manner as described in “VCL 02 One Table No Styles”.
        This is the output from invoking option “VCL 04 One Table w Styles”.
        mcg18

      • VCL 06 Master Detail w Styles
      • The user is prompted for the data in the same manner as described in “VCL 03 Master Detail No Styles”.  This is the output from invoking option “VCL 05 Master Detail w Styles”.
        mcg19

    • Load DB
      This option

    • Reports
      mcg21

      • Details Report
        mcg20
      • All Information
      • Single Categorymcg22

     

    The popup menu for the Skeletons Project tab are as follows.
    mcg02

    • Position Master Database
    • Export Project
    • Import Existing Project
    • Import New Project

    The popup menu for the Skeleton Workbench is as follows.
    mcg03

    • Position Details Database
    • Import File
    • Export File

    The popup menu to print items in the Skeleton Contents tab is a follows.
    mcg04
    When the user clicks on the Print This One option the following report listing is generated.
    mcg05

    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.

BCS Delphi XE8 Zip Interface

There are those time when zip files are required and for those time I recommend using the BCS Delphi XE8 Zip Interface.

z01

When you click on the Select Zip menu item the following dialog appears.

z02

The file list box is then populated with all the zip files at that location.
z03
When you double click on any item in the list of zips the following dialog will appear.
z04
This dialog list all the possible actions for the selected zip file.

  • Execute
    This feature will invoke the 7 zip interface for subsequent use.
    z05
  • Search
    The Search option allow the user to specify a search string and all the zip file contents file specifications that match the search string will be highlighted.
    z06
    When the user clicks OK the following results appear.
    z07
    All items containing the string to detect are highlighted.
  • Rename
    When the user clicks on the Rename option the following dialog will appear.
    z08
    Move the mouse over the New File Name area and designate the new file name.  The rename is made in the interface is updated.
  • Create New Zip
    When the user desires to create a new zip file the following dialog appears.
    z09
    Then the following dialog appears.
    z10
    When you click on the Yes button a zip you have specified is created.  Care should be taken if a zip already exists that has the same name.  I recommend renaming the existing zip to a new file name and let the newly created zip occupy the default zip name.  This approach allows the zip file versioning.
  • Delete Zip File
    To delete and existing file double click over that file and the following confirmation will appear.
    z11
    When the user selects the Yes option the designated zip file is deleted.

As you can see this utility will handle every scenario when creating or utilizing zip files.

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.