Contents

The Application Server and web publishing are available with Alpha Five Version 6 and above.

Section

Description

Getting Started

Introduction

Web Publishing Capabilities

Overview of the Development Environment

Configuring the Application Server

Starting the Application Server

Starting the HTML Editor

Configuring the Development Environment

Creating a New Webroot Profile

Creating a New Project

Adding a File to a Project

Building Components

and Pages

Introducing the Grid Builder

Creating a Grid Component

Formatting Grid Controls

Adding a Search Form

Adding a Detail View Form

Displaying Repeating Forms

Adding Summary Fields to a Grid

Displaying Field1 While Storing Field2

Displaying Multiple Tables with a View

Displaying Multiple Tables with a GridLinker

Microsoft Access : Creating a Grid Based on a Table or View

Microsoft Access: Creating a Grid Using the SQL Builder

Programming
Fundamentals

Web Publishing vs. ASP Programming

Running Xbasic in an A5W Page

Editing the Xbasic

Understanding the Programming Process

How Pages are Rendered

About Xbasic

Where to Place Your Xbasic Code

Separating HTML from Xbasic

Inserting Data into the HTML Code Stream

Calling UDFs from a Grid or Dialog Component

Creating and
Using Variables

Creating and Using Variables

Using the DIM Statement

Naming Variables

Using Operators and Calculating Values

Xbasic Operators and Functions

Using Variables Inside HTML Tags

Outputting Variables

Understanding Data Types

Assigning and Using Variables

Choosing the correct data type

Creating constants

Adding comments

 

Understanding Variable Scope

Understanding and Using Session Variables

Understanding and Using Dot Variables

Understanding
Functions

Understanding Functions

Using an Xbasic Function

Where to Place Functions

Using a Function with a Parameter

Running a Page in LivePreview

Common Character Functions

More Character Functions

Time and Date Functions

Writing Your Own Function

Declaring the Types of Function Arguments

Declaring the Type of the Return Value

Returning Multiple Values from a Function

Making Statements
Conditional

Making Statements Conditional

Using the IF ... THEN ... ELSE Statement

Using a Logical Variable

Understanding Inequalities

Using the .AND. and .OR. Operators

Nested IF ... THEN Statements

Using SELECT CASE Statements

Running a Statement
Multiple Times
with a Loop

Running a Statement Multiple Times with a Loop

Using a FOR ... NEXT Loop

Using the STEP Argument in a FOR ... NEXT Loop

Exiting from a FOR ... NEXT Loop

Creating an Array

Using FOR ... NEXT with an Array

About Methods

Using a WHILE Loop with an Equality Test

Using a WHILE Loop with a Logical Variable

Using Nested FOR ... NEXT Loops

Using Nested WHILE Loops

How to use FOR EACH ... NEXT

How to use *FOR EACH()

Using Web Forms

Using Web Forms

Request.script name

Using Text Boxes

Using List Boxes

Using Multiple Selection List Boxes

Using Radio Buttons

Using Check boxes

Grid Component Filtering

Filtering a Grid with a Dialog

Filtering a Grid with a Menu Selection

Filtering a Grid with a Grid Selection

Filtering a Grid with a Button

Filtering a Grid with Range Search

Filtering a Grid with Quick Search

Filtering a Grid with a Session Variable

Filtering an ADO Grid with a Session Variable

Grid Component Techniques

Controlling a Field's Width

Write-Only Grid Component

Responding to User Input on a Grid

Adapting to a Different Server Date Format

A Simple Bar Chart

Displaying Images from a Table

Using Radio Buttons to Select a Record

Using Check Boxes to Select Records

Dynamic Column Headings

Keeping a Calendar Control Current

Automatically Populating Linking Field Values

Displaying Tiled Images

Populating a Drop Down Box with a Variable

Displaying Multiple Fields in a Drop Down List

Suppressing Blank Fields in an Address

Updating Hidden Grid Fields

Creating a Grid that Looks Like a Dialog

Hiding Controls That are Filled by a Lookup

Highlighting Search Terms in Grid Records

Locking Individual Records

Custom Controls on an Editable Grid

Sorting a Grid on Multiple Fields

Dialog Component
Techniques

Using a Dialog as a Search Form

Cascading Selection Lists

Setting Focus to a Field on a Dialog

Displaying a Selected Record in a Dialog

Ordering Lookup Entries

Navigation System Component Techniques

Highlighting the Current Page in a Menu

Creating an Email Link Navigation Entry

GridLinker Component Techniques

Single Parent Style GridLinker Component

Overriding Gridlinker Component Settings

Placing Unrelated Grids in a Tabbed gridlinker

Page Techniques

Building A5W Web Pages

Starting with a Standard HTML Page

Inserting a Component

Starting with the Web Component Builder

Deleting Web Components

Publishing a Page to a Server

Creating a Login Page

Sending Filter and Order Expressions to a Page

Access to Files Outside the Webroot

Placing SimpleCharts on a Web Page

Creating a Session Variable when Clicking on a Link

Creating a Button with a Hyperlink

Implementing Security

Implementing Version 8 Security

Defining Security Settings

Finishing the Login Page

Defining Page Security

Adding Users from the Desktop

Adding Users with a Web Component

Testing Page Security

Alpha Five Techniques

Printing Reports

Understanding the AfterValidate Script

Filtering, Printing, and Emailing a Report

Printing a Dialog as PDF

Sending an Email

Running Saved Operations

Uploading and Displaying Images

Creating an
Alpha Five Database

Creating an Alpha Five Database

Key Terms and Concepts

Using the Control Panel

Control Panel Buttons

Alpha Five File Types

Creating a New Database

Creating Tables

Using the Table Editor

Defining Data Fields

Numeric Data Fields

Indexing Data Fields

Creating Tables for AlphaMovies

Defining Field Rules

Publishing AlphaMovies

Reading and Writing
Alpha Five Tables

Reading and Writing Alpha Five Tables

About Objects and Pointers

Displaying Data From a Table

Navigating Through a Table

The Table Methods You Should Know

Returning a Different Field Than You Display

Using a WHILE ... END WHILE Loop

Using TABLE.EXTERNAL RECORD CONTENT GET()

Packing Alpha Five Tables

See Also

Contents

Supported By

Alpha Five Version 8 Profession Edition