[Table of Contents]

Introduction to Database-Enabled Web Documents
Requirements for Using Database Wizard
Overview of the Database Wizard
Connecting to Access Database Off-Line
Creating Table Block Showing Table Contents
Fine-tune Web Documents Created by Database Wizard

 

Create Web Documents (Table Block) Including Table Contents Connecting Access Database

Creates table block that displays multiple records arranged in rows and columns, with field names in the header row.

1. Select [Database > Table Block...] from the Insert menu.

2. Specify the document type, the type of database connection, and the Web server operating system for a database-enabled document created using the Database Wizard. If your Web server runs Windows NT, the default selections are usually appropriate then press Next.

Document Type

3. In step 2, select a data source for the current document and enter your user name and password to access the database, then press Next.

Data Source

The field information of the table named Contact is shown below.

Field name

Data Type

ID

integer

Company

string

Address

string

Phone

string

Fax

string

Country

string

3. In connected database, select fields from the table and press Add button. The field name is added in the form of "Table name.Field name". Click Next.

Database Fields

4. Enter a SQL statement to select the records that will be displayed in the current block, and to determine their sort order. In this example, we entered the filed name, "Contacts.ID", as the Order to sort by IDs.

Selection Statement

5. In Block Elements step, select the fields that will be displayed the table block. Click Next.

Block Elements

6. Set the maximum number of records per page for a table block in this step of the Database Wizard. Click Finish.

List Settings

After the last step of List Form Wizard, table will appear in Edit window.

Table Block

Check the table in Preview window.

Inserted Table Block

 

Namo Interactive Inc.

This document is created using Namo WebEditor 4 on August 2, 2000.

 

© 2001 Namo Interactive Inc. All rights reserved.