5.4.7 Creating an Application from a Generated SQL Script

Create an application from a saved script in SQL Scripts.

When you save a script, you can view, run, and modify the script in SQL Scripts. After you run the saved script, you can run the Create Application Wizard from SQL Scripts page. The wizard recognizes any tables and adds report and form pages for each table.

To create an application from saved SQL script:

  1. On the Workspace home page, click the SQL Workshop icon.
  2. Click SQL Scripts.
    The SQL Script page appears.
  3. Run the saved script:
    1. Locate the script and click Run.
    2. On Run Script, click Run Now.

      The Results page appears.

  4. To create an application, click Create App.

    The Create Application Wizard appears.

    Note:

    Creating a database application is a multiple step process. Once you specify the application name and appearance, you add pages, select features, and configure application settings.
  5. In the Create Application Wizard:
    1. Enter the application name, select an appearance, add pages, select features, and configure application settings.
    2. Click Create Application.