| Q |
|
Question Mark Use with BOOLEAN Variables
|
|
QUOTE$ Function
|
| R |
|
RAD Function
|
|
RANDOMIZE Statement
|
|
Read and write Binary Files
|
|
READ Statement
|
|
Read/Write the Windows Registry
|
|
%READONLY Directive - INPUT DIALOGBOX Statement
|
|
REAL Function
|
|
Real Number Data Type
|
|
Real Numeric Constants
|
|
Record Size in Database SETUP
|
|
Records in Database Tables
|
|
REDIM Statement #1
|
|
REDIM Statement #2
|
|
REEXTRACT TABLE ... END EXTRACT
|
|
Registry
|
|
Relational Operations on Strings
|
|
Relational Operators
|
|
REMAINDER Function
|
|
REPEAT
|
|
REPEAT DO Statement
|
|
REPEAT FOR Statement in FOR Loop
|
|
REPEAT$ Function
|
|
REPEAT ROUTINE Statement
|
|
REPLACE$ Function
|
|
%REPLACE Menu Directive
|
|
Replace Multiple Values on a Field Name
|
|
Replacing IIS with SPINS Webserver
|
|
Report Heading in SETUP
|
|
REQ
|
|
Reserved Words
|
|
Reserved words
|
|
Restore ARS Database
|
|
RESTORE Statement #1
|
|
RESTORE Statement #2
|
|
RESUME statement in HANDLER routine
|
|
RETRY statement in HANDLER routine
|
|
Reuseable (Private) Routines in Different Applications
|
|
REVERSE - Screen Attribute
|
|
RIGHT[$] Function
|
|
Right Trim Function
|
|
RND Function
|
|
RND function
|
|
ROTATE Directive Used with PRINT USING
|
|
ROTATE Option with FORMAT$
|
|
ROUND Function
|
|
Routine Definitions
|
|
ROUTINE/END ROUTINE Statements
|
|
Routine Template
|
|
Routine Template: Optional Parameters
|
|
Routines
|
|
Passing Parameters
|
|
Private Variables #1
|
|
Private Variables #2
|
|
Routines in Sheerpower
|
|
Row on Screen
|
|
RPAD$ Function
|
|
RSET FILL Statement
|
|
RSET Statement #1
|
|
RSET Statement #2
|
|
RTFDECODE$ Function
|
|
RTFENCODE$ Function
|
|
RTRIM$ Function
|
|
RUN Command
|
|
Run Web-Based Applications on Multiple Ports
|
|
Running a Sheerpower Program
|
|
Runtime Exception Messages
|
| S |
|
Salt Integer #1
|
|
Salt Integer #2
|
|
Sample Programs
|
|
Display and Update Database
|
|
EVAL_HANDLER.SPSRC
|
|
Expression Evaluator
|
|
MATRIX.SPSRC Web Scripting
|
|
Simple Menu
|
|
Sample Sheerpower Programs Included With Installation
|
|
Sample Web Form Script Program
|
|
Saving a Program in Sheerpower
|
|
SCAN Function
|
|
Screen Attributes
|
|
BLINK
|
|
BOLD
|
|
REVERSE Video
|
|
Screen Clearing with CLEAR Statement
|
|
Screen Column
|
|
Screen Coordinates
|
|
Screen Format Characters
|
|
Screen Format Options
|
|
AJ - Auto Jump
|
|
AT row, column
|
|
BOLD, BLINK, REVERSE
|
|
DIGITS
|
|
ELAPSED Time
|
|
LCASE
|
|
NOECHO
|
|
REQ - required
|
|
UCASE
|
|
VALID
|
|
Screen Mask in SETUP
|
|
SCREEN Option in INPUT
|
|
SCREEN Option - User Response
|
|
Screen Row
|
|
SCREENMASK - Field Definition Item
|
|
Script Area in MATRIX.SPSRC
|
|
Script Areas
|
|
Scripting Language
|
|
Scripting Programs Location
|
|
Search, Find and Replace Keystrokes
|
|
SEC Function
|
|
SECONDS Function
|
|
SEG$ Function
|
|
Segmentation in Programs
|
|
Segmenting Long Code Into Distinct Routines
|
|
SELECT CASE Construct
|
|
SELECT CASE Statement
|
|
Select Keystrokes
|
|
SELECT Tag
|
|
SELECT Tag Attributes
|
|
Semantics in SETUP
|
|
Semicolon in PRINT Statement
|
|
Sending Email
|
|
Sending Email Sample Program
|
|
SET AUTOEXIT Statement
|
|
SET BACK OFF statement
|
|
SET BACK ON Statement
|
|
SET/CANCEL WATCH in Debug
|
|
SET #chnl_num options
|
|
CURRENT
|
|
MARGIN
|
|
ZONEWIDTH
|
|
SET #chnl_num statement
|
|
SET ERROR OFF Statement
|
|
SET ERROR ON Statement
|
|
SET EXIT OFF Statement
|
|
SET EXIT ON statement
|
|
Set Explicit Target and Replacement Text with SmartCopy
|
|
SET HELP OFF Statement
|
|
SET HELP ON Statement
|
|
SET ICON statement
|
|
SET MARGIN Statement
|
|
SET PROGRAM TIMEOUT Statement
|
|
SET SCROLL Statement
|
|
SET Statements
|
|
SET SYSTEM: CLIPBOARD Statement
|
|
SET SYSTEM: COMMENT Statement
|
|
SET SYSTEM, LOGICAL: VALUE Statement
|
|
SET SYSTEM: PROCESS Statement
|
|
SET SYSTEM, SYMBOL: VALUE Statement
|
|
SET TABLE: CURRENT
|
|
SET TABLE: EXTRACTED 0
|
|
SET TABLE, FIELD: KEY
|
|
SET TABLE, FIELD: PARTIAL KEY
|
|
SET TABLE: ID
|
|
SET TABLE Options
|
|
SET TABLE: POINTER
|
|
SET TABLE #string_expr...
|
|
Set Taskbar Icon Sample Program
|
|
SET WINDOW AREA Statement
|
|
SET WINDOW: COLUMN Statement
|
|
SET WINDOW: CURRENT Statement
|
|
SET WINDOW: DATA Statement
|
|
SET WINDOW: KEYMAP Statement
|
|
SET WINDOW KEYSTROKE: VALUE Statement
|
|
SET WINDOW: ROW Statement
|
|
SET WINDOW: TYPEAHEAD Statement
|
|
SET ZONEWIDTH Statement
|
|
SETUP Data Types
|
|
SETUP Field Definitions and Key Fields
|
|
SGN Function
|
|
SHARE Option in Access Outin and Access Output
|
|
Sheerpower
|
|
Coding Standards Manual
|
|
SheerPower
|
|
Compile Errors List
|
|
Sheerpower
|
|
Creating Input Forms
|
|
Data Types
|
|
Database Engine Interfaces
|
|
Exception Errors List
|
|
Keystrokes in SPDEV
|
|
Network and Operating System Interface
|
|
Program Elements
|
|
Program Files
|
|
Program Structure
|
|
Text Windows TEXTWINDOW://
|
|
Web Scripting
|
|
sheerpower: as a logical
|
|
Sheerpower Code Areas
|
|
Sheerpower Coding Standards
|
|
Sheerpower Commands and Statements
|
|
Sheerpower Console Window
|
|
Sheerpower Data Tables/Structures
|
|
Sheerpower Development Environment
|
|
Sheerpower Error Message Display
|
|
Sheerpower Exact Math
|
|
Sheerpower Internet Services (SPINS) Webserver
|
|
Sheerpower License Key
|
|
SHEERPOWER Menu Item in SPDEV
|
|
Sheerpower Professional Application Development
|
|
Sheerpower Rapid Development Environment
|
|
Sheerpower Reserved Words #1
|
|
Sheerpower Reserved Words #2
|
|
Sheerpower Security
|
|
Sheerpower Support
|
|
Sheerpower Tag
|
|
ATTACHED Attribute
|
|
AUTOSCALE Attribute
|
|
AUTOSUBMIT Attribute
|
|
BACKGROUND [image] Attribute
|
|
COLOR Attribute
|
|
HEIGHT Attribute
|
|
SRC Attribute
|
|
TITLE Attribute
|
|
TYPE Attribute
|
|
WIDTH Attribute
|
|
Sheerpower Tag Attributes
|
|
Sheerpower Tag in INPUT DIALOGBOX
|
|
Shift Keystrokes
|
|
SHOW ALL in Debug
|
|
SHOW CALLS in Debug
|
|
SHOW FILES in Debug
|
|
SIN Function
|
|
Single Field Name Smart Copy, Paste & Replace
|
|
SINH Function
|
|
SIZE function
|
|
%SIZE Menu Directive
|
|
SKIP Function
|
|
Smart Selection in SPDEV
|
|
SmartCopy
|
|
Duplicating Lines
|
|
Multiple Replacement Values on a Field Name
|
|
Rapid Correction of Text Through Replacement
|
|
Set Explicit Target and Replacement Text
|
|
Setup
|
|
Single Field Name Copy Paste & Replace
|
|
Smart Copy & Paste on Code Snippets and Paragraphs
|
|
Smart Copy & Paste on OPEN Statements
|
|
Using SmartCopy
|
|
Software Maintenance
|
|
SORT
|
|
ASCENDING
|
|
DESCENDING
|
|
Within EXTRACT TABLE
|
|
SORT Attribute to <th> Tag in INPUT DIALOGBOX
|
|
SORT$ Function
|
|
SORT KEYS in EXTRACT
|
|
Sorting Extracted Records
|
|
Sound WAV Files
|
|
SP4GL.INI: Edit to Set Logicals
|
|
SPACE$ Function
|
|
%SPCODE Tag
|
|
SPDEV
|
|
Abbreviations
|
|
Automatic File Backup
|
|
Built In Program Templates
|
|
Creating a New Program File
|
|
Debug Comments
|
|
Default File Location & File Type
|
|
Deploying a Program
|
|
Develop Professional Applications: Features
|
|
Error Message Display
|
|
Expansions
|
|
Getting Started
|
|
GOLD/O to Organize Routines
|
|
Help
|
|
Open Existing Files
|
|
Program Template
|
|
Purge Backup Files
|
|
Routine Definitions
|
|
Routine Template
|
|
Running a program
|
|
Saving a Program
|
|
Smart Selection Features
|
|
Special Keystrokes
|
|
Spelling Correction
|
|
Using GOLD/R to make a subroutine
|
|
Validating a Program
|
|
SPDEV Keystrokes
|
|
Alt Keystrokes
|
|
Ctrl Keystrokes
|
|
Disable Keypad Editing
|
|
Editing Keystrokes
|
|
F Keystrokes
|
|
GOLD Key
|
|
Gold Keystrokes
|
|
Keypad Editing Keystrokes
|
|
Keystroke Combinations
|
|
Keystrokes For Movement Within a File
|
|
Learn and Macros Keystrokes
|
|
Popular Keystrokes
|
|
Programming Keystrokes
|
|
Search, Find and Replace Keystrokes
|
|
Shift Keystrokes
|
|
SPDEV Menu Items
|
|
ADVANCED
|
|
Change System Settings
|
|
DISPLAY
|
|
EDIT
|
|
FILE
|
|
FIND
|
|
HELP
|
|
Keystroke Function Mappings
|
|
OPTIONS
|
|
PROJECTS
|
|
SHEERPOWER
|
|
WINDOW
|
|
Specify Any Root Folder
|
|
Spelling Correction in SPDEV
|
|
Spelling Correction with the TAB Key in the Console
|
|
SPINC File Extension: Include Files
|
|
SPINS Webserver
|
|
Localhost Port
|
|
Location and Directory Structure
|
|
Multiple Ports
|
|
Options
|
|
Replacing IIS
|
|
Run For The First Time
|
|
Run Simultaneously with IIS
|
|
Specify Any Root Folder
|
|
Test
|
|
spins_webserver -? Options Command
|
|
%SPLIT Menu Directive
|
|
SPRUN Files
|
|
SPRUN Files - Password Protect
|
|
%SPSCRIPT Tag
|
|
.SPSRC extension
|
|
SPSRC File Extension
|
|
SQR Function
|
|
SRC - Sheerpower Tag Attribute
|
|
Starting Position in Database SETUP
|
|
Statement Presentation
|
|
Statements
|
|
ADD STRUCTURE ... END ADD
|
|
ADD TABLE ... END ADD
|
|
ASK #chnl_num
|
|
ASK ERRORS
|
|
ASK KEYSTROKES
|
|
ASK MARGIN #1
|
|
ASK MARGIN #2
|
|
ASK PAGESIZE
|
|
ASK RESPONSES
|
|
ASK/SET SEED
|
|
ASK/SET SYSTEM: CLIPBOARD
|
|
ASK/SET SYSTEM: COMMENT #1
|
|
ASK/SET SYSTEM: COMMENT #2
|
|
ASK/SET SYSTEM, SYMBOL 'DNS:xxx': VALUE str$
|
|
ASK/SET SYSTEM, SYMBOL 'OS:xxx': VALUE str$
|
|
ASK/SET WINDOW: CURRENT
|
|
ASK/SET WINDOW: KEYMAP
|
|
ASK SYSTEM: DIRECTORY
|
|
ASK SYSTEM, LOGICAL: VALUE
|
|
ASK SYSTEM: MODE
|
|
ASK SYSTEM: PARAMETER
|
|
ASK SYSTEM: PID
|
|
ASK SYSTEM: PROCESS
|
|
ASK SYSTEM: PROGRAM
|
|
ASK SYSTEM: RIGHTS
|
|
ASK SYSTEM, SYMBOL: VALUE
|
|
ASK SYSTEM: USER
|
|
ASK TABLE Options
|
|
ASK WINDOW AREA
|
|
ASK WINDOW: COLUMN
|
|
ASK WINDOW: DATA
|
|
ASK WINDOW: ROW
|
|
ASK WINDOW: TYPEAHEAD
|
|
ASK ZONEWIDTH
|
|
BREAK
|
|
CALL
|
|
CANCEL ADD
|
|
CANCEL EXTRACT
|
|
CASE
|
|
CASE ELSE
|
|
CASE IS
|
|
CAUSE EXCEPTION
|
|
CHAIN
|
|
CLEAR
|
|
CLOSE ALL #1
|
|
CLOSE ALL #2
|
|
CLOSE #chnl_num
|
|
CLOSE TABLE
|
|
CONTINUE in HANDLER routine
|
|
CSET
|
|
CSET FILL
|
|
DATA
|
|
DEBUG ON/OFF
|
|
DECLARE
|
|
DECLARE TABLE
|
|
DELAY
|
|
DELETE TABLE
|
|
DIM
|
|
DISPATCH
|
|
DO in DO/LOOP
|
|
END
|
|
END DO
|
|
EXCLUDE in EXTRACT TABLE
|
|
EXECUTE
|
|
EXIT ADD
|
|
EXIT DO
|
|
EXIT EXTRACT
|
|
EXIT FOR
|
|
EXIT FOR in FOR/NEXT Loop
|
|
EXIT HANDLER in HANDLER routine
|
|
EXIT ROUTINE
|
|
EXTRACT TABLE ... END EXTRACT
|
|
FOR EACH ... NEXT Table
|
|
FOR in FOR/NEXT Loop
|
|
HALT
|
|
IF/THEN...END IF
|
|
INCLUDE in EXTRACT TABLE
|
|
INPUT
|
|
INPUT #chnl_num
|
|
INPUT DIALOGBOX #1
|
|
INPUT DIALOGBOX #2
|
|
ITERATE
|
|
ITERATE DO
|
|
ITERATE FOR in FOR/NEXT Loop
|
|
KEY INPUT
|
|
KILL (File)
|
|
LET
|
|
LIBRARY
|
|
LINE INPUT
|
|
LINE INPUT #chnl_num
|
|
LIST STATS
|
|
LOCK/UNLOCK TABLE
|
|
LOOP in DO/LOOP
|
|
LSET
|
|
LSET FILL
|
|
MAILTO://
|
|
MEDIA Statement
|
|
MESSAGE
|
|
MESSAGE ERROR Statement
|
|
NEXT in FOR/NEXT Loop
|
|
OPEN #chnl_num: NAME
|
|
OPEN FILE
|
|
OPEN HTTP:// HTTPS://
|
|
OPEN STRUCTURE
|
|
OPEN TABLE
|
|
OPTION BASE #1
|
|
OPTION BASE #2
|
|
OPTION REQUIRE DECLARE
|
|
PASS
|
|
PASS [NOWAIT | NORETURN | WINDOW | TIMEOUT]
|
|
PRINT
|
|
PRINT #chnl_num
|
|
PROGRAM
|
|
RANDOMIZE
|
|
READ
|
|
REDIM
|
|
REEXTRACT TABLE ... END EXTRACT
|
|
REPEAT
|
|
REPEAT DO
|
|
REPEAT FOR in FOR/NEXT Loop
|
|
REPEAT ROUTINE
|
|
RESTORE
|
|
RESUME in HANDLER routine
|
|
RETRY in HANDLER routine
|
|
ROUTINE/END ROUTINE
|
|
RSET
|
|
RSET FILL
|
|
SELECT CASE/END SELECT
|
|
SET AUTOEXIT
|
|
SET BACK OFF
|
|
SET BACK ON
|
|
SET/CANCEL WATCH
|
|
SET #chnl_num
|
|
SET ERROR OFF
|
|
SET ERROR ON
|
|
SET EXIT OFF
|
|
SET EXIT ON
|
|
SET HELP OFF
|
|
SET HELP ON
|
|
SET PROGRAM TIMEOUT
|
|
SET SCROLL
|
|
SET SYSTEM: DIRECTORY
|
|
SET SYSTEM, LOGICAL: VALUE
|
|
SET SYSTEM: PROCESS
|
|
SET SYSTEM, SYMBOL: VALUE
|
|
SET TABLE Options
|
|
SET WINDOW AREA
|
|
SET WINDOW: COLUMN
|
|
SET WINDOW: DATA
|
|
SET WINDOW KEYSTROKE: VALUE
|
|
SET WINDOW: ROW
|
|
SET WINDOW: TYPEAHEAD
|
|
SET ZONEWIDTH
|
|
SHOW ALL
|
|
SHOW CALLS
|
|
SHOW FILES
|
|
SORT in EXTRACT TABLE
|
|
STATS OFF
|
|
STATS ON
|
|
STOP
|
|
TRACE ON/OFF
|
|
UNLOCK ALL:COMMIT
|
|
UNLOCK TABLE:COMMIT
|
|
WHEN EXCEPTION IN/USE/END WHEN
|
|
WHEN EXCEPTION USE
|
|
STATISTICS Feature in Debug
|
|
STATS ON/OFF in Debug
|
|
STEP in Debug
|
|
STEP Option in FOR/NEXT Loop
|
|
STEP Options in Debug
|
|
Stock Quote Sample Program
|
|
STOP Statement
|
|
STR$ Function
|
|
String Constants
|
|
String Data
|
|
String Delimiters
|
|
String EDIT$
|
|
String Expressions - Concatenated
|
|
String Format Characters in PRINT USING
|
|
String Manipulation Functions
|
|
ASCII
|
|
BASE64DECODE$
|
|
BASE64ENCODE$
|
|
CHANGE$
|
|
CHARSET$
|
|
CHR$
|
|
CONVERT
|
|
CONVERT$
|
|
CPAD$
|
|
EDIT$
|
|
ELEMENT$
|
|
ELEMENTS
|
|
ENCODE$
|
|
FORMAT$
|
|
GEODISTANCE$
|
|
GETSYMBOL$
|
|
GETWORD$
|
|
HASH$
|
|
HTMLDECODE$
|
|
HTMLENCODE$
|
|
LCASE$
|
|
LEFT[$]
|
|
LEN
|
|
LPAD$
|
|
LTRIM$
|
|
MATCHWORD
|
|
MAXLEN
|
|
MEM()
|
|
MID[$]
|
|
ORD
|
|
ORDNAME$
|
|
PARSE$
|
|
PHASH$
|
|
PIECE$
|
|
PIECES
|
|
PRETTY$
|
|
QUOTE$
|
|
REPEAT$
|
|
REPLACE$
|
|
RIGHT[$]
|
|
RPAD$
|
|
RTFDECODE$
|
|
RTFENCODE$
|
|
RTRIM$
|
|
SEG$
|
|
SORT$
|
|
SPACE$
|
|
STR$
|
|
TAB
|
|
TRIM$
|
|
UCASE$
|
|
UNQUOTE$
|
|
URLDECODE$
|
|
URLENCODE$
|
|
UUID$
|
|
VAL
|
|
WRAP$
|
|
XLATE$
|
|
String Search & Compare Functions
|
|
COMPARE
|
|
ITEM
|
|
MATCH
|
|
PATTERN
|
|
POS
|
|
SCAN
|
|
SKIP
|
|
String Searching and Comparing Functions
|
|
Structure References
|
|
Structure Security in Database SETUP
|
|
Structures/Tables
|
|
Submenu Indicator
|
|
Submit buttons in INPUT DIALOGBOX
|
|
Submit Buttons in INPUT DIALOGBOX - Images
|
|
Subroutines using GOLD/R in SPDEV
|
|
Substrings
|
|
Summary of CGI Environment Variables
|
|
Supported HTML Tags in INPUT DIALOGBOX
|
|
Syntax Errors: DDE
|
|
System Settings in SPDEV
|
|
SYSTEXT$
|
|
SYSTEXT$ Function
|