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
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
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
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
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
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
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
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
Supported By
Alpha Five Version 8 Profession Edition