SheerPower^® 4GL
A Guide to the SheerPower Language

M
mailto:// file open option
MAIN namespace
Maintain User Abbreviations in SPDEV
Maintain User Expansions
Maintain User Expansions menu item in SPDEV
Marking Code to Run Once
MATCH function
Math - precision
Mathematical Precision in SheerPower
Matrix.spsrc - How it works
Matrix Web Scripting Program Sample
MAX function
MAXLEN function
MAXNUM function
Media files
MEDIA Statement
Media Statement Sample Program
MEM() function
Menu data value
Menu descriptions
Menu directives
%AT row, column
CENTER keyword
%ATTACHED #1
%ATTACHED #2
%BAR
%COLUMNS
%HEADING
%INACTIVE
%ITEMS
%LOCKSTEP
%MENUBAR
%MESSAGE
%MULTI
%NOMOUSEOVER
%REPLACE
%SIZE number
%SPLIT
%TITLE
%WIDTH
Menu elements
menu item default
Menu items
MENU option in INPUT
Menu path - tracing
Menu user interface
%MENUBAR menu directive
MESSAGE ERROR incrementing error counter
%MESSAGE ERROR program directive
%MESSAGE menu directive
%MESSAGE program directive
MESSAGE statement
DELAY option
ERROR option
Messages
compile errors
exceptions
MID[$] function
MIN function
Miscellaneous Functions
MOD function
Most Popular Keystrokes in SPDEV
Mouse usage
%MULTI menu directive
Multi-table databases
Multiple Commands in the SP4GL Console Window
Multiple occurrence fields
Multiple statements on a single line
Multiple variables in LINE INPUT #chnl_num
Music files
N
NAME - field definition item
Namespace, default of "main"
Namespace in routines
Namespace, variables
Nested DO/LOOP
Nesting FOR/NEXT loops
Network and Operating System Interface
New file in SPDEV
NEXT statement in FOR/NEXT loop
%NOMOUSEOVER menu directive
NORETURN option of PASS
NOWAIT option of PASS
NULL - field definition item
Null string
NUMBER - field definition item
Numeric expressions
Numeric format characters in PRINT USING
O
OBJECT in DTYPE function
Occur in SETUP
ODBC #1
ODBC #2
ODBC - Accessing with SheerPower
ODBC Data Source Setup
ODBC Data Source Setup - Create New Data Source
ODBC Data Source Setup - Data Source Name and Description
ODBC Data Source Setup - ODBC Data Source Administrator
ODBC Data Source Setup - ODBC Microsoft Access Setup
ODBC Data Source Setup - ODBC Microsoft Access Setup Complete
ODBC Data Source Setup - Select Database
ODBC Database Engine
ODBC Overview
ODBC Sample MyContacts Database Location
ODBC - syntax for accessing password protected ODBC databases
%ONCE Tag
Open CGI connection
OPEN #chnl_num options
ACCESS
LOCK
OPTIMIZE OFF
UNFORMATTED
UNIQUE
OPEN #chnl_num statement
OPEN FILE statement
OPEN STRUCTURE
ACCESS option
DATAFILE option
LOCK option
Opening a structure
Opening files #1
Opening files #2
OPTIMIZE OFF option in OPEN #chnl_num
OPTIMIZED - field definition item
OPTION BASE statement #1
OPTION BASE statement #2
OPTION REQUIRE DECLARE statement
OPTIONS menu item in SPDEV
Options - SPINS webserver
ORD function
Order of evaluation
ORDERED LIST tag
ORDNAME$ function
Organization in SETUP
Outin - appending data to a file
Output to textwindow
P
Page size of screen
PARAGRAPH tag
Parameter Passing Using WITH and RETURNING
PARSE$ function
Parsing Input Dialogbox Results
PARTIAL KEY option in EXTRACT STRUCTURE
PASS NORETURN statement
PASS NOWAIT statement
PASS print
PASS statement
PASS statement to print output
PASS TIMEOUT
PASS URL
PASS WINDOW statement
Passing integer arrays to external routines from SheerPower
Passing Optional Parameters to Routines
Passing parameters with private variables
Password Protect SPRUN files
Password protected ODBC database - syntax
Paste Keystrokes
Path - specifying default path for TYPE attribute
PATTERN function
Performance of SheerPower CGI interface
PERSIST Tags - SheerPower Web Scripting
PI function
PIECE$ function
PIECES function
Pivot Date
Playing Media Files using the MEDIA Statement
Port - specify different port to use for SPINS webserver #1
Port - specify different port to use for SPINS webserver #2
POS function
POSITION - field definition item
Preallocated Records in SETUP
Precision Math in SheerPower Sample Program
PREFORMATTED TEXT tag
PRETTY$ function
PRINT #chnl_num
Print Mask in SETUP
PRINT statement
AT row, column
cursor positioning
ERASE option
item separater
comma
semicolon
printing numbers
TAB function
USING option
PRINT USING #1
PRINT USING #2
directives
format characters
numeric format characters
string format characters
PRINT USING directives
DATE
HYPHEN
LCASE
ROTATE
TIME
UCASE
ZIPCODE
Print zones
comma
Printing data
Printing HTML Output
Printing numbers with PRINT statement
Printing output using PASS #1
Printing output using PASS #2
Printing to a file
Printing to a terminal
PRINTMASK - field definition item
Private Routines
private routines
Private Routines in different applications
Private Routines in SheerPower
Private routines with own namespace
Private variables #1
Private variables #2
Private variables with passing parameters
Processing CGI requests
Processing CGI requests from the SPINS server
Program description
Program directives
Program elements
Program examples
Program line
Program Segmentation
PROGRAM statement
program structure
Program Template
Programming Keystrokes
PROJECTS menu item in SPDEV
PROMPT - field definition item
PROMPT option in INPUT
Prompt Text in SETUP
Purge backup files in SPDEV
Purge current file versions