<PREV     NEXT>

Active-Link Tables

Data from Different Backends

An extremely powerful new feature of Alpha Five is Heterogeneous Joins i.e. the ability to create Forms and Reports that join data from multiple remote SQL databases. In this video we show an example of an Order Header table which is stored in SQL Server, and an Order Detail table which is stored in MySQL. An Alpha Five set is built that joins these two tables and a Form based on this Set allows us to edit and enter data into both databases.

 

Watch Video


This image has been scaled to fit on this page.
Click for fullsize image

On the next page, you will see a form that was created using this heterogeneous join.

 

 

 

Download       Order