SheerPower^® 4GL
A Guide to the SheerPower Language

Chapter 16
16	Database Setup
16.1	SETUP--Overview
16.1.1	Entering SETUP
16.2	SETUP Structure Definition
16.2.1	Structure Name
16.2.2	Database Engine
16.2.3	Data Set
16.2.4	Data dictionary
16.3	SETUP - Properties and Procedures
16.3.1	Data Field Definitions
16.3.1.1	Name
16.3.1.2	Classification
16.3.1.3	Description
16.3.1.4	Data Type
16.3.1.5	Starting Position
16.3.1.6	Length
16.3.1.7	Occurs
16.3.1.8	Prompt Text
16.3.1.9	Semantics
16.3.1.10	Report Heading
16.3.1.11	Print Mask
16.3.1.12	Screen Mask
16.3.1.13	Help Text
16.3.1.14	Access Rules
16.3.1.15	Validation Rules
16.3.1.16	Field Definitions and Key Fields - General Information
16.3.2	Modifying an Existing Data Field
16.3.3	Deleting Field Information
16.3.4	Viewing and Printing Definitions
16.4	Structure Security
16.5	Creating the Data File
16.5.1	Record Size
16.5.2	Preallocated Records
16.5.3	Organization
16.5.4	Key Field Information
16.5.5	Create Data File
Chapter 17
17	SheerPower and ODBC
17.1	ODBC--Overview
17.1.1	ODBC Data Source Setup
17.1.2	Accessing ODBC with SheerPower
17.2	Accessing Password Protected ODBC Databases
Chapter 18
18	SheerPower Internet Services (SPINS) Webserver
18.1	SPINS Webserver Location and Directory Structure
18.1.1	Stop Microsoft IIS Webserver
18.1.2	Test SPINS_Webserver
18.1.3	Specify a Different Port Number
18.1.3.1	Run Web-based Applications on Multiple Ports
18.1.4	Specify Any Root Folder
18.1.5	SPINS Webserver Options
Chapter 19
19	Writing Network Applications and Accessing Devices
19.1	Accessing Data from Webpages
19.2	Sending Email
19.3	Webserver CGI Interface
19.3.1	SheerPower 4GL CGI Interface Sample Program
19.3.2	Testing the CGI Interface
19.3.3	How the EVAL_HANDLER Program Works
19.3.4	Waiting for CGI Requests
19.3.5	Processing CGI Requests
19.3.6	Building CGI Custom HTTP Headers
19.3.7	CGI Interface Performance Considerations
19.3.8	Summary of CGI Environment Variables
19.4	Using TCP/IP and UDP Protocols
19.4.1	TCP/IP Protocol
19.4.2	UDP Protocol
19.5	Communication Port Support
Chapter 20
20	SheerPower Web Scripting
20.0.1	Chapter Overview
20.1	Running the Sample Script Programs
20.1.1	Sample Web Form Script Program
20.1.2	Sample Matrix Web Script Program
20.1.3	How the Matrix Sample Program Works
20.1.3.1	Script Area in Matrix.spsrc
20.1.3.2	Code Area in Matrix.spsrc
20.1.3.3	Use of GETSYMBOL$() in Matrix.spsrc
20.2	Defining CODE and SCRIPT Areas
20.3	SheerPower Script Areas
20.3.1	Embedding SheerPower Code Inside a Script Area
20.4	SheerPower Code Areas
20.4.1	Displaying Complex Expression Results
20.4.2	Embedding Script Areas in Code Areas with %INCLUDE
20.4.3	CGI Environment Symbols - GETSYMBOL$ Function
20.4.3.1	Embedded Code for CGI Symbol Lookups
20.5	High Performance PERSIST Tags
20.5.1	Marking Code to Run Once
20.6	Location of SheerPower Scripting Programs
20.6.1	How to Invoke a SheerPower Script Program in the Browser