SheerPower^® 4GL
A Guide to the SheerPower Language

Index
Index
Examples
1-1	Menu Program
1-2	Menu Program
1-3	Quiz Program Example
1-4	NEWS Headline Program Example
1-5	Expression Evaluator Program Example
1-6	SheerPower program error message
1-7	Presentation of command and statement information
2-1	Print command in the SP4GL Console Window
2-2	Entering multiple commands in the SP4GL Console Window
2-3	Print command in the SP4GL Console Window
2-4	Command recall in the SP4GL Console Window
2-5	Command completion
2-6	Command completion
2-7	Spelling correction
2-8	Program example
2-9	BUILD command in SP4GL Console Window
2-10	BUILD command in SP4GL Console Window with file specification
2-11	RUN command
2-12	RUN command with file specification
2-13	Listing program lines
2-14	HALT statement
2-15	Show files after using the HALT command
2-16	GO command
2-17	DEBUG ON
2-18	TRACE ON/OFF
2-19	STATS ON
2-20	Listing statistics in DEBUG system
2-21	Using BREAK in DEBUG system
2-22	Using STEP in DEBUG system
3-1	SheerPower program example
3-2	Program statement
3-3	SheerPower Reserved Words
3-4	END statement
3-5	STOP statement
3-6	ROUTINE/END ROUTINE statements
3-7	Namespace
3-8	Private Routine - Example
3-9	Executing routines/subroutines by name
3-10	EXIT ROUTINE statement
3-11	REPEAT ROUTINE statement
3-12	Parameter Passing Using WITH and RETURNING
3-13	Private variables in routines
3-14	Passing parameters with private variables
3-15	Error messages when passing routine parameters
3-16	Multiple statements on a single line
3-17	Continuing program lines using the AMPERSAND (&)
3-18	Comma-separated list continuation
3-19	Implied continuation with '+', 'AND'
3-20	Comments in programs - (//)
3-21	Comment text
3-22	Routine header sample
3-23	Comments with line continuation
3-24	Debug comments
3-25	%COMPILE program directive
3-26	%MESSAGE program directive
3-27	%MESSAGE ERROR program directive
3-28	%INCLUDE program directive
4-1	SheerPower Exact Math
4-2	SheerPower Exact Math
4-3	String data
4-4	BOOLEAN variables
4-5	String constants and delimiters
4-6	Substrings
4-7	Substrings used to change string value
4-8	SheerPower data structure
4-9	String expressions
4-10	String expression with string variable
4-11	Performing relational operations on strings
4-12	Bit manipulation
5-1	DECLARE statement
5-2	Declaring multiple data types
5-3	DECLARE STRUCTURE
5-4	OPTION REQUIRE DECLARE statement
5-5	LET statement
5-6	Assigning numeric values with LET statement
5-7	LSET, RSET and CSET
5-8	RSET statement
5-9	LSET statement
5-10	RSET statement
5-11	CSET statement
5-12	LSET, RSET, CSET FILL statements
5-13	DATA, READ, RESTORE Statements
5-14	DATA items containing commas
5-15	DATA and READ statements
5-16	RESTORE statement
5-17	Private variables in routines
5-18	DIM statement
5-19	REDIM statement
5-20	OPTION BASE statement
6-1	CEIL function
6-2	DIV0 function
6-3	FP function
6-4	INT function
6-5	INTEGER function
6-6	IP function
6-7	MAX function
6-8	MIN function
6-9	MOD function
6-10	REAL function
6-11	REMAINDER function
6-12	RND function
6-13	ROUND function
6-14	TRUNCATE function
6-15	ABS function
6-16	ACOS function
6-17	ANGLE function
6-18	ASIN function
6-19	ATN function
6-20	COS function
6-21	COSH function
6-22	COT function
6-23	CSC function
6-24	DEG function
6-25	EXP function
6-26	LOG function
6-27	LOG2 function
6-28	LOG10 function
6-29	PI function
6-30	RAD function
6-31	SEC function
6-32	SGN function
6-33	SIN function
6-34	SINH function
6-35	SQR function
6-36	TAN function
6-37	TANH function
6-38	DATE function
6-39	DATE$ function
6-40	DAYS function
6-41	DAYS function - integer values
6-42	DAY$ function
6-43	FULLTIME$ function
6-44	SECONDS function
6-45	TIME function
6-46	TIME(5) function
6-47	TIME$ function
6-48	Pivot Date Logical
6-49	ASCII function
6-50	CHANGE$ function
6-51	CHARSET$ function
6-52	CHR$ function
6-53	CONVERT$ function - supported data types
6-54	CONVERT function
6-55	CPAD$ function
6-56	EDIT$ function
6-57	ELEMENTS function
6-58	ELEMENT$ function
6-59	ELEMENT$ function - separators
6-60	ELEMENT$ function - separators
6-61	ENCODE$ function
6-62	FORMAT$ function
6-63	FORMAT$ function
6-64	DATE format with FORMAT$
6-65	GETSYMBOL$ function - SheerPower Symbol& Trimming Option
6-66	GETSYMBOL$ function - HTML form submission
6-67	GETSYMBOL$ function - CGI Environment Symbol
6-68	GETSYMBOL$ function - Operating System Symbol
6-69	HASH$ function
6-70	LCASE$ function
6-71	LEFT [$] function
6-72	LEN function
6-73	LPAD$ function
6-74	LTRIM$ function
6-75	MAXLEN function
6-76	MEM function
6-77	MID [$] function
6-78	ORD function
6-79	ORDNAME$ function
6-80	PARSE$ function
6-81	PIECE$ function
6-82	PRETTY$ function
6-83	QUOTE$ function
6-84	REPEAT$ function
6-85	REPLACE$ function
6-86	RIGHT [$] function
6-87	RPAD$ function
6-88	RTRIM$ function
6-89	SEG$ function
6-90	SORT$ function
6-91	SPACE$ function
6-92	STR$ function
6-93	TAB function
6-94	TRIM$ function
6-95	UCASE$ function
6-96	UNQUOTE$ function
6-97	URLENCODE$ function
6-98	URLDECODE$ function
6-99	VAL function
6-100	WRAP$ function
6-101	XLATE$ function
6-102	COMPARE function
6-103	ITEM function
6-104	ITEM function
6-105	MATCH function
6-106	PATTERN function - ?
6-107	PATTERN function -*
6-108	PATTERN function - { }
6-109	PATTERN function - {^ }
6-110	PATTERN function - ~
6-111	PATTERN function - { \|nnn,nnn,nnn \| }
6-112	PATTERN function - { <cc \|ccc \|c > }
6-113	PATTERN function - {(word_text) }
6-114	PATTERN function - { \|directive \| }
6-115	POS function
6-116	SCAN function
6-117	SKIP function
6-118	_BACK system function
6-119	_EXIT system function
6-120	_HELP system function
6-121	_REPLY system function
6-122	_TERMINATOR system function
6-123	Validation rules - ALLOW
6-124	Validation rules - DISALLOW
6-125	Validation rules - MINLENGTH
6-126	Validation rules - MAXLENGTH
6-127	Validation rules - LENGTH
6-128	Validation rules - CHARACTERS
6-129	Validation rules - NOCHARACTERS
6-130	Validation rules - LETTERS
6-131	Validation rules - LCASE
6-132	Validation rules - UCASE
6-133	Validation rules - DIGITS
6-134	Validation rules - DECIMALS
6-135	Validation rules - NUMBER
6-136	Validation rules - INTEGER
6-137	Validation rules - INTEGER WORD
6-138	Validation rules - DATE DMONY
6-139	Validation rules - DATE DMONCY
6-140	Validation rules - FULLTIME
6-141	Validation rules - REQUIRED
6-142	Validation rules - REQUIRED
6-143	Validation rules - VRULES
6-144	Validation rules - PRINTMASK
6-145	Validation rules - EXPRESSION
6-146	Validation rules - CODE
6-147	Validation rules - MENU
6-148	Validation rules - ROUTINE
6-149	Validation rules - FILTER - CHANGE
6-150	Validation rules - FILTER - RESTORE
6-151	_CHANNEL system function
6-152	_EXTRACTED system function
6-153	FILEINFO$ function
6-154	FILEINFO$ function
6-155	FILEINFO$ function
6-156	FILEINFO$ function - CONTENTS
6-157	Copy a file with FILEINFO$ CONTENTS
6-158	FINDFILE$ function
6-159	FINDFILE$ function
6-160	_DEBUG system function
6-161	_STATUS system function
6-162	_STRING system function
6-163	EXLABEL$ function
6-164	EXTEXT$ function
6-165	EXTYPE function
6-166	SYSTEXT$ function
6-167	DECODE function
6-168	DTYPE function
6-169	EVAL function
6-170	FALSE function
6-171	LBOUND function
6-172	MAXNUM function
6-173	SIZE function
6-174	TRUE function
6-175	UBOUND function
7-1	PRINT statement
7-2	Print expression
7-3	Semicolon in PRINT statement
7-4	Commas and Print Zones
7-5	Printing long data in records
7-6	TAB in PRINT statement
7-7	AT row, column in PRINT statement
7-8	ERASE in PRINT statement
7-9	Printing numbers with PRINT statement
7-10	Printing negative numbers with PRINT statement
7-11	Printing integers of 12 or fewer digits
7-12	Cursor positioning in PRINT statement
7-13	Printing Attributes--Highlighting Options
7-14	USING option in PRINT statement - print_mask
7-15	PRINT USING
7-16	String format characters in PRINT USING
7-17	String format characters in PRINT USING
7-18	Numeric format characters in PRINT USING
7-19	Numeric format characters in PRINT USING
7-20	Numeric format characters in PRINT USING - negative and positive numbers
7-21	Numeric format characters in PRINT USING
7-22	Numeric format characters in PRINT USING
7-23	< character in PRINT USING
7-24	> character in PRINT USING
7-25	@ character in PRINT USING
7-26	. character in PRINT USING
7-27	, character in PRINT USING
7-28	% character in PRINT USING
7-29	* character in PRINT USING
7-30	* character in PRINT USING
7-31	+ character in PRINT USING
7-32	- character in PRINT USING
7-33	~ character in PRINT USING
7-34	$ character in PRINT USING
7-35	$+ characters in PRINT USING
7-36	$ characters in PRINT USING
7-37	+$ characters in PRINT USING
7-38	$- characters in PRINT USING
7-39	UCASE directive used with PRINT USING
7-40	LCASE directive used with PRINT USING
7-41	HYPHEN directive used with PRINT USING
7-42	DATE directive used with PRINT USING
7-43	ROTATE directive used with PRINT USING
7-44	TIME directive used with PRINT USING
7-45	ZIPCODE directive used with PRINT USING
7-46	MESSAGE statement
7-47	ERROR option in MESSAGE statement
7-48	DELAY option in MESSAGE statement
7-49	DELAY statement
7-50	CLEAR statement - clearing the screen
7-51	CLEAR AREA
7-52	CLEAR AREA BOX - BOLD, BLINK, REVERSE attributes
8-1	INPUT statement
8-2	Simple input style
8-3	Formatted data entry screens
8-4	Free format multi-line text input
8-5	Pop-up menus
8-6	Inputting Strings
8-7	Simple input statement
8-8	Validating data prior to storing it into a structure
8-9	LINE INPUT statement
8-10	Input default prompt and text
8-11	PROMPT option
8-12	AT option
8-13	ATTRIBUTES Option
8-14	LENGTH option
8-15	DEFAULT option
8-16	_STRING system function
8-17	ERASE option
8-18	VALID option
8-19	TIMEOUT option
8-20	AREA Option
8-21	SCREEN option
8-22	Screen format characters -#
8-23	Screen format characters -@
8-24	Screen format characters - .
8-25	Screen Format Characters -^
8-26	Screen Format Characters - ~
8-27	Screen format options - UCASE
8-28	Screen format options - LCASE
8-29	Screen format options - NOECHO
8-30	Screen format options - DIGITS
8-31	Screen format options - AJ
8-32	Screen format options - AT row, column
8-33	Screen format options - VALID
8-34	Screen format options - ELAPSED
8-35	Screen format options - ELAPSED
8-36	Screen format options - BOLD, BLINK, REVERSE
8-37	Enter key with INPUT SCREEN
8-38	MENU option in INPUT
8-39	%ATTACHED menu directive
8-40	%BAR menu directive
8-41	%COLUMNS menu directive
8-42	%HEADING menu directive
8-43	%ITEMS menu directive
8-44	%LOCKSTEP menu directive
8-45	%MENUBAR menu directive
8-46	%MESSAGE menu directive
8-47	%SPLIT menu directive
8-48	%WIDTH menu directive
8-49	%INACTIVE menu directive
8-50	%NOMOUSEOVER menu directive
8-51	KEY INPUT statement
8-52	_TERMINATOR system function
9-1	INPUT DIALOGBOX
9-2	Parsing Input Dialogbox Results
9-3	%ERROR Directive
9-4	%FOCUS Directive
9-5	%READONLY Directive
9-6	<sheerpower > tag
9-7	<sheerpower > tag attributes - COLOR, HEIGHT, WIDTH, TITLE
9-8	<sheerpower > tag attributes - BACKGROUND
9-9	<sheerpower > tag attributes - SRC
9-10	<sheerpower > tag attributes - AUTOSUBMIT
9-11	<sheerpower > tag attributes - TYPE FILTER
9-12	<sheerpower > tag attributes - TYPE =OPEN
9-13	<sheerpower > tag attributes - TYPE =SAVEAS
9-14	<sheerpower > tag attributes - TYPE =SELECT
9-15	<form >... </form > tag
9-16	<a >... </a > tag
9-17	<input > tag
9-18	<input > tag attributes
9-19	Custom Submit Buttons
9-20	Image Submit Buttons
9-21	<select >... </select > tag
9-22	<select > tag and attributes
9-23	<textarea >... </textarea > tag
9-24	<center >... </center > tag
9-25	<p >... </p > tag
9-26	<br > tag
9-27	<ol >... </ol > tag
9-28	<ul >... </ul > tag
9-29	<hr > tag
9-30	<img > tag
9-31	<img > attributes tag
9-32	<div >... </div > tag
9-33	<font >... </font > tag
9-34	<h1 >... </h1 > tag
9-35	<h2 >... </h2 > tag
9-36	<h3 >... </h3 > tag
9-37	<h4 >... </h4 > tag
9-38	<h5 >... </h5 > tag
9-39	<h6 >... </h6 > tag
9-40	<b >... </b > tag
9-41	<i >... </i > tag
9-42	<em >... </em > tag
9-43	<pre >... </pre > tag
9-44	<address >... </address > tag
9-45	<blockquote >... </blockquote > tag
9-46	<table >... </table > tag
9-47	<table > tag attributes
9-48	<th >... </th > tag
9-49	<tr >... </tr > tag
9-50	<td > tag
9-51	Inserting String Variable Data into a Form
9-52	Inserting Numeric Variable Data into a Form
9-53	Storing a select option into a variable for displaying later
9-54	Storing a select option into a variable for displaying later
10-1	FOR/NEXT loop
10-2	STEP option in FOR/NEXT loop
10-3	Nesting FOR/NEXT loops
10-4	EXIT FOR statement in FOR loop
10-5	REPEAT FOR statement in FOR loop
10-6	REPEAT FOR used within a nested loop
10-7	ITERATE FOR statement in FOR loop
10-8	ITERATE FOR used in a nested loop
10-9	DO LOOP
10-10	Infinite DO/LOOP
10-11	WHILE option in DO/LOOP
10-12	UNTIL option in DO/LOOP
10-13	WHILE and UNTIL options in DO/LOOP
10-14	EXIT DO statement
10-15	REPEAT DO statement
10-16	REPEAT DO within a nested loop
10-17	ITERATE DO statement
10-18	ITERATE DO used in a nested loop
10-19	EXECUTE statement
10-20	EXECUTE statement
10-21	END IF in IF/THEN statement
10-22	ELSE option in IF/THEN
10-23	ELSEIF option in IF/THEN
10-24	SELECT CASE/END SELECT
10-25	CASE statement
10-26	CASE statement - checking for a range of values
10-27	CASE ELSE statement
10-28	CASE IS statement
10-29	CHAIN statement
10-30	PASS Statement
10-31	PASS NOWAIT statement
10-32	PASS NORETURN statement
10-33	PASS WINDOW statement
10-34	PASS NOWAIT \| NORETURN, WINDOW:
10-35	PASS TIMEOUT:
10-36	PASS Print
10-37	PASS URL: Opening an .HTML file
10-38	DISPATCH statement
11-1	SET AUTOEXIT
11-2	SET BACK ON statement
11-3	SET BACK OFF statement
11-4	SET ERROR ON statement
11-5	SET ERROR OFF statement
11-6	ASK ERRORS statement
11-7	SET EXIT ON statement
11-8	SET EXIT OFF statement
11-9	SET HELP ON statement
11-10	SET HELP OFF statement
11-11	SET ICON statement
11-12	ASK KEYSTROKES statement
11-13	SET MARGIN statement
11-14	ASK PAGESIZE statement
11-15	ASK RESPONSES statement
11-16	SET SCROLL statement
11-17	Randomize statement
11-18	ASK/SET SEED statement
11-19	ASK SYSTEM: COMMENT statement
11-20	SET SYSTEM: COMMENT statement
11-21	ASK SYSTEM: DIRECTORY statement
11-22	ASK SYSTEM: DIRECTORY statement
11-23	ASK SYSTEM, LOGICAL: VALUE statement
11-24	SET SYSTEM, LOGICAL: VALUE statement
11-25	Set Logicals in SP4GL.INI
11-26	ASK SYSTEM: MODE statement
11-27	ASK SYSTEM: PARAMETER statement
11-28	ASK SYSTEM: PROCESS statement
11-29	SET SYSTEM: PROCESS statement
11-30	ASK SYSTEM: PROGRAM Statement
11-31	ASK SYSTEM: RIGHTS statement
11-32	ASK SYSTEM, SYMBOL: VALUE statement
11-33	DNS Lookups using ASK SYSTEM, SYMBOL
11-34	DNS Lookup that does not exist
11-35	SET SYSTEM, SYMBOL: VALUE statement
11-36	ASK SYSTEM, SYMBOL 'OS:xxx': VALUE statement
11-37	ASK SYSTEM: USER statement
11-38	ASK WINDOW AREA statement

Contents

Index

SheerPower® 4GL A Guide to the SheerPower Language

SheerPower^® 4GL
A Guide to the SheerPower Language