Working with Complex Databases

Some users have more complex database structures such as:

Databases owners other than dbo in Microsoft SQL Server.
Multiple databases on the same server requiring foreign key relationships between them.
Multiple schemas in Oracle containing related tables.
Linked databases in Microsoft Access or Microsoft SQL Server.

Iron Speed Designer has a number of features that, when combined with features of the database product, allow you to take advantage of the complex database structures in your application.

The easiest way to take advantage of these features is to:

Create a database view within your primary database or schema to retrieves all records from the other database, schema or from another owner’s schema. This can be done by specifying a query such as:

SELECT * FROM dbXYZ.Customers

In this query, all rows from the Customers table belonging to dbXYZ are retrieved. This query can be saved as a View in the primary database being used by the Iron Speed Designer application.
After creating the database view in your database, use the view in Iron Speed Designer via:

The Application Wizard, by creating a set of pages.
The New Page Wizard, by creating a page.
Selecting the “Include this table/view in the application” option on the Database Properties screen.

After linking the database view, create a Virtual Primary Key for the view in Iron Speed Designer.
Create any necessary Virtual Foreign Key relationships between this view and other tables or views.

After performing the above steps, you can create applications using these complex database structures. When the schema changes, update the view in the database product, and then re-scan for changes from within Iron Speed Designer.

Working with Complex Databases

See Also