BCS Master Detail Info

To supply the necessary information to an application employing the master detail scenario many considerations need to be addressed and passed forward for subsequent processing.

Since the MySQL relational database management system (DBMS) can be extensive our fist task to establish a starting point within MySQL.

If you do not require the front end simply complete entries for the “dbi” parameters and invoke the frm006c.frmShowModal.  Your master detail application will be available for data entry.

mdi01

When the user selects the desired item by double clicking the desired item the next dialog appears positioned to that location.

mdi02

Notice the dialog handles requirements for the master and detail table.  When the user selects the OK button the process continues.

mdi03

Select the OK button to remove the dialog then click the control to select the master.  Notice when the master table i selected the members are automatically populated .

mdi04

If we click on the OK control now the following dialog appears.

mdi05

Click the OK control here to clear the dialog and select the detail table.  Notice the data elements automatically populate the data elements control.

mdi06

When we continue by clicking on the OK control the following dialog appears>

mdi07

Click the OK control to remove this message and select the desired key for the master.

mdi08

We are now read to continue so click the OK control once more.  Notice the following dialog appears.

mdi09

Click the OK control to clear the dialog and select the desired detail key.  The following dialog will appear.

mdi10

The remaining task is to identify which data elements to use for the index for the master and then the detail scenario.

mdi11

mdi12

Our final destination is of course the master detail scenario which is depicted below.  Notice zero lines of code are required and zero dfm files are used.

mdi13

The next view shows the data entry panel for the master table.

mdi14

The next view reveals the detail grid.

mdi15

The next view shows the detail data entry panel.

mdi16

This of course is only the tip of the iceberg when it comes to the possibilities of having the computer generate source code or finished application without requiring a single line of code.  Did I mention there are no dfm files in this application.

Enjoy!

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.