Sheerpower^®
A Guide to the Sheerpower Language

Appendix O
Appendix O	Smart Editing in Sheerpower
O.1	Overview
O.1.1	Smart Copy and Paste (Programming Keystroke)
O.1.2	Setup SmartCopy in SPDEV
O.1.2.1	Using SmartCopy
O.1.2.2	Single Field Name Smart Copy, Paste & Replace
O.1.2.3	Multiple Replacement Values on a Field Name
O.1.2.4	Set Explicit Target and Replacement Text
O.1.2.5	Rapid Correction of Text Through Replacement
O.1.2.6	Duplicating Lines of Text
O.2	Smart Selection
Index
Index
Examples
1-1	Menu Program
1-2	Menu Program Example
1-3	Display and Update Database Program Example
1-4	Expression Evaluator Program Example
1-5	Presentation of Command and Statement Information
2-1	PRINT Command in the Console Window
2-2	Multiple Commands in the Sheerpower Console
2-3	Print Date Command in the Sheerpower Console Window
2-4	Command recall in the Console Window
2-5	Command Completion in the Console Window
2-6	Command Completion in the Console Window
2-7	Spelling Correction in the Console Window
2-8	BUILD Command in the Console Window - Full File Path
2-9	RUN Command
2-10	Listing Program Lines
2-11	HALT Statement
2-12	Using SHOW ALL in DEBUG
2-13	Sample SHOW ALL Debug Text File
2-14	Using SHOW CALLS in DEBUG system
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
2-23	STEP OVER Command
2-24	STEP OUT Command
2-25	Using SET/CANCEL WATCH in DEBUG system
3-1	Basic 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 With "&" (AMPERSAND)
3-18	Comma-Separated List Continuation
3-19	Implied Continuation With '+', 'AND'
3-20	Comments In Programs With //
3-21	Comments in Programs
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
3-29	%DEBUG 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	Data Table
4-9	Multiple Occurrence Fields
4-10	String Expressions
4-11	String Expression with String Variable
4-12	Performing Relational Operations on Strings
4-13	Bit Manipulation
4-14	Use of Parentheses for Clarity in Operations
5-1	DECLARE statement
5-2	Declaring Multiple Data Types
5-3	DECLARE TABLE
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	BASE64ENCODE$ Function
6-51	BASE64ENCODE$ Function: Encoding With Whitespace
6-52	BASE64ENCODE$ Function: Encoding Without Whitespace
6-53	BASE64ENCODE$ Function With CRLF Inserted
6-54	BASE64ENCODE$ Function With No CRLF Inserted
6-55	BASE64DECODE$ Function
6-56	BASE64DECODE$ Function#2
6-57	CHANGE$ Function
6-58	CHARSET$ Function
6-59	CHR$ Function
6-60	CONVERT$ Function: Supported Data Types
6-61	CONVERT Function
6-62	CPAD$ Function
6-63	EDIT$ Function
6-64	ELEMENTS Function
6-65	ELEMENT$ Function
6-66	ELEMENT$ Function: Separators
6-67	ELEMENT$ Function: Separators
6-68	ENCODE$ Function
6-69	FORMAT$ Function
6-70	FORMAT$ Function - Overflow
6-71	DATE Format with FORMAT$
6-72	GEODISTANCE$ Function
6-73	GETSYMBOL$ Function: Sheerpower Symbol& Trimming Option
6-74	GETSYMBOL$ Function: HTML form submission
6-75	GETSYMBOL$ Function: CGI Environment Symbol
6-76	GETSYMBOL$ Function: Operating System Symbol
6-77	GETWORD$ Function
6-78	HASH$ Function
6-79	HASH$ Function With Salt
6-80	Prime Hashing With No Salt Integer
6-81	HTMLDECODE$ Function
6-82	HTMLENCODE$ Function
6-83	LCASE$ Function
6-84	LEFT [$] Function
6-85	LEN Function
6-86	LPAD$ Function
6-87	LTRIM$ Function
6-88	MATCHWORD Function
6-89	MAXLEN Function
6-90	MEM Function
6-91	MID [$] Function
6-92	ORD Function
6-93	ORDNAME$ Function
6-94	PARSE$ Function
6-95	PHASH$ Function
6-96	PHASH$ Function With Salt
6-97	PIECE$ Function
6-98	PRETTY$ Function
6-99	QUOTE$ Function
6-100	REPEAT$ Function
6-101	REPLACE$ Function
6-102	RIGHT [$] Function
6-103	RPAD$ Function
6-104	RTFENCODE$ Function
6-105	RTFDECODE$ Function
6-106	RTRIM$ Function
6-107	SEG$ Function
6-108	SORT$ Function
6-109	SPACE$ Function
6-110	STR$ Function
6-111	TAB Function
6-112	TRIM$ Function
6-113	UCASE$ Function
6-114	UNQUOTE$ Function
6-115	URLENCODE$ Function
6-116	URLDECODE$ Function
6-117	UUID$ Function
6-118	VAL Function
6-119	WRAP$ Function
6-120	XLATE$ Function
6-121	COMPARE Function
6-122	ITEM Function
6-123	ITEM Function
6-124	MATCH Function
6-125	PATTERN Function - ?
6-126	PATTERN Function -*
6-127	PATTERN Function - { }
6-128	PATTERN Function - {^ }
6-129	PATTERN Function - ~
6-130	PATTERN Function - { \|nnn,nnn,nnn \| }
6-131	PATTERN Function - { <cc \|ccc \|c > }
6-132	PATTERN Function - {(word_text) }
6-133	PATTERN Function - { \|directive \| }
6-134	POS Function
6-135	POS Function
6-136	SCAN Function
6-137	SKIP Function
6-138	_BACK System Function
6-139	_EXIT System Function
6-140	_HELP System Function
6-141	_REPLY System Function
6-142	_TERMINATOR System Function
6-143	Validation Rules - ALLOW
6-144	Validation Rules - DISALLOW
6-145	Validation Rules - MINLENGTH
6-146	Validation rules - MAXLENGTH
6-147	Validation Rules - LENGTH
6-148	Validation Rules - CHARACTERS
6-149	Validation Rules - NOCHARACTERS
6-150	Validation Rules - LETTERS
6-151	Validation Rules - LCASE
6-152	Validation Rules - UCASE
6-153	Validation Rules - DIGITS
6-154	Validation Rules - DECIMALS
6-155	Validation Rules - NUMBER
6-156	Validation Rules - INTEGER
6-157	Validation rules - INTEGER WORD
6-158	Validation Rules - DATE DMONY
6-159	Validation Rules - DATE DMONCY
6-160	Validation Rules - FULLTIME
6-161	Validation Rules - REQUIRED
6-162	Validation Rules - REQUIRED
6-163	Validation Rules - VRULES
6-164	Validation Rules - PRINTMASK
6-165	Validation Rules - EXPRESSION
6-166	Validation Rules - CODE
6-167	Validation Rules - MENU
6-168	Validation Rules - ROUTINE
6-169	Validation Rules - FILTER - CHANGE
6-170	Validation Rules - FILTER - RESTORE
6-171	_CHANNEL System Function
6-172	_EXTRACTED System Function
6-173	FILEINFO$ Function
6-174	FILEINFO$ Function
6-175	FILEINFO$ Function
6-176	FILEINFO$ Function - CONTENTS
6-177	Copy a File With FILEINFO$ CONTENTS
6-178	FINDFILE$ Function
6-179	FINDFILE$ Function
6-180	FINDFILE$ Function
6-181	_DEBUG System Function
6-182	_STATUS System Function
6-183	_STRING System Function
6-184	EXLABEL$ Function
6-185	EXTEXT$ Function
6-186	EXTYPE Function
6-187	SYSTEXT$ Function
6-188	DECODE Function
6-189	DTYPE Function
6-190	EVAL Function
6-191	FALSE Function
6-192	LBOUND Function
6-193	MAXNUM Function
6-194	SIZE Function
6-195	TRUE Function
6-196	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
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 Console
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	Inputting Multiple Variables
8-8	Validating Data Prior to Storing into a Table
8-9	LINE INPUT Statement
8-10	Input Default Prompt and Text
8-11	PROMPT Option
8-12	AT row, col 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
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 Statement
10-32	PASS NOWAIT Statement
10-33	PASS NORETURN Statement
10-34	PASS WINDOW Statement
10-35	PASS NOWAIT \| NORETURN, WINDOW:
10-36	PASS TIMEOUT:
10-37	PASS PRINT
10-38	PASS URL: Opening an HTML File
10-39	DISPATCH Statement

Contents

Index

Sheerpower® A Guide to the Sheerpower Language

Sheerpower^®
A Guide to the Sheerpower Language