Step 4: Select Pages to Create

Select one or more database tables to create web pages.

Iron Speed Designer provides a variety of built-in page templates it uses automatically create web pages for the database tables and views you select to use in your application.  Automatically creating web pages based on your database schema accelerates your application development by giving you these pages for any database table, or database view in your application.  After creating an initial set of web pages, you can further customize them with Iron Speed Designer.

Using Iron Speed Designer, you can use any number of database tables to your application from any number of databases on the same or different database server machines.  There is no practical limit on the number of tables, and their related pages, you can use or reference in your application.

After selecting the specific database tables you wish to use in your application, Iron Speed Designer queries the designated database and collects the selected tables’ schemas as well as related foreign key relationship information.  Specifically, Iron Speed Designer uses the table schemas in order to create the appropriate SQL queries and database access code.  Similarly, the foreign key information is used in multi-table joins and other similar SQL queries.

Configure Page Type options

Each page type has its own group of options which is specific for that page type. You can change the configuration options of any page type by clicking the Configure button or right clicking the page type in the Pages step of the Application Wizard. For more information search in Part II of the Help for 'New Page and Panel Configuration Options'.

Ownership Requirements for Microsoft SQL Server Databases

In some cases, certain Microsoft SQL Server tables or databases may not be displayed in the column of Tables and Views.  You must be the “owner” (or “dbo” in Microsoft SQL Server parlance) of the databases and database tables in order for Iron Speed Designer to use them to create web pages.  To enable “dbo”:

Step 1:  Open your SQL Express Explorer and locate your database.

Step 2:  Navigate to the Security folder in your database.  This folder will have the Users listed.

Step 3:  Select the user that you would like to log in as.  

Step 4:  Right-click on this user and select the 'Properties' option.

Step 5:  Click on the 'General' tab in the properties panel.  This tab has a field titled ' Default Schema'. Make sure the value entered in this text box is 'dbo'.  Beneath this tab, is another list box that has a list of Role Members.  Make sure 'db_owner' is checked.

Related topics

Creating Edit Record and Show Record pages for database views

Missing Edit Record and Show Record pages

Database, Table, and Field Name Restrictions

File Naming Conventions

Many-To-Many relationships

Gallery Page

Gallery with Overlaid Text Page

Quick Selector Page

Infinite Pagination

Mobile Pages