HOME PAGE

Introduction
  How It Works
  Assumptions

Getting started

First Time Use
  Setup

Tutorial

Changing Data
  Data Structure
  Data
  Relationship
  Index
  Comments

Distributing Your New Front End

Data PRO Links

Data Start BannerData PRO Banner

Data

You may choose to change data using an SQL statement or by invoking a query. If the "Query" option is selected, then a combo box showing all the available queries is displayed.

Data Options

 

Example

Execute a SQL statement

We created a field called 'SalesTax' in our previous example with default value set to '0'. Now we will use a SQL statement to convert all NULL records to '0' in the 'SalesTax' field.

  1. Select Data.
  2. Then select SQL option and type the SQL statement to create the table (i.e. 'UPDATE Customers SET SalesTax = 0 WHERE SalesTax IS NULL).
  3. Now click the 'Process' button to execute the SQL statement.

Your Data version is now 2.

Previous Button Next Button

Footer SSW