SheerPower® 4GL
A Guide to the SheerPower Language


Previous Contents Index

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
Recalling commands when in the SP4GL Console Window
Record Size in SETUP
Records in structures
REDIM statement
redim statement
REEXTRACT STRUCTURE ... END EXTRACT
Registry
Relational operators
REMAINDER function
REPEAT
REPEAT DO statement
REPEAT FOR statement in FOR loop
REPEAT$ function
REPEAT ROUTINE statement
REPLACE$ function
Replace IIS with SPINS
%REPLACE menu directive
Report Heading in SETUP
REQ
Requests - processing CGI requests
Requests - waiting for CGI requests
Reserved words #1
Reserved words #2
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
RND function #1
RND function #2
Root-Level for the Browsing of Files
ROTATE directive used with PRINT USING
ROTATE option with FORMAT$
ROUND function
Routine Definitions
ROUTINE/END ROUTINE statements
Routine Header Template in SPDEV
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
RTRIM$ function
RUN command
Running Sample Script Programs
Running SPINS and IIS Simultaneously #1
Running SPINS and IIS Simultaneously #2
Running SPINS on Multiple Ports
Running SPINS the first time #1
Running SPINS the first time #2
Runtime exception messages
S
Sample Program
Sample SheerPower Programs Included with SheerPower 4GL Install
Sample Web Form Script Program
SCAN function
Screen attributes
    BLINK
    BOLD
    REVERSE video
Screen clearing
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
Script Program Examples
Scripting
Scripting - Displaying the results of complex expressions
Scripting Environment Variables
Scripting programs - Location
Search, Find and Replace Keystrokes
SEC function
SECONDS function
SEG$ function
Segmentation in Programs
Segmenting long code
SELECT CASE construct
SELECT CASE statement
Select Keystrokes
SELECT tag
SELECT Tag Attributes
Semantics in SETUP
Semicolon in PRINT statement
Sending Email with SheerPower #1
Sending Email with SheerPower #2
SET/ASK statements
SET AUTOEXIT statement
SET BACK OFF statement
SET BACK ON statement
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 HELP OFF statement
SET HELP ON statement
SET ICON
SET ICON statement
SET MARGIN statement
SET SCROLL statement
SET STRUCTURE: CURRENT
SET STRUCTURE: EXTRACTED 0
SET STRUCTURE, FIELD: KEY
SET STRUCTURE, FIELD: PARTIAL KEY
SET STRUCTURE: ID
SET STRUCTURE options
SET STRUCTURE: POINTER
SET STRUCTURE #string_expr...
SET SYSTEM: COMMENT statement
SET SYSTEM, LOGICAL: VALUE statement
SET SYSTEM: PROCESS statement
SET SYSTEM, SYMBOL: VALUE statement
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
Setting Logicals in SP4GL.INI
SETUP
    Access Rules
    Classification
    Create Data File
    Creating the Data File
    Data dictionary
    Data Set
    Data Type
    Deleting Field Information
    Description
    Field Definition - Name
    Field Definitions
    Field Definitions and Key Fields
    Help Text
    Key Field Information
    Length
    Modifying an Existing Field
    Occurs
    Organization
    Preallocated Records
    Print Mask
    Procedures
    Prompt Text
    Record size
    Report Heading
    Screen Mask
    Semantics
    Starting Position
    Structure Security
    Validation Rules
    Variable Field Lengths
    Viewing and Printing Definitions
SETUP Create Data File
SETUP Creating the Data File
SETUP Data Type
SETUP Deleting Field Information
SETUP - Description
SETUP Field Definition
SETUP Field Definitions
SETUP Field Definitions and Key Fields
SETUP Key Field Information
SETUP Modifying an Existing Field
SETUP Organization
SETUP Preallocated Records
SETUP properties and procedures
SETUP Record Size
SETUP Routine #1
SETUP Routine #2
SETUP Structure Definition
SETUP Structure Security
SETUP Viewing and Printing Definitions
SGN function
SheerPower
    getting help
SheerPower 4GL
    Network and Operating System Interface
    recalling previous commands in the console window
    Web Scripting
SheerPower 4GL License
sheerpower: as a logical
SheerPower Code Areas
SheerPower coding standards
SheerPower Coding Standards Manual
SheerPower command - what it does
SheerPower Commands and Statements
SheerPower compile errors
SheerPower - creating forms
SheerPower data management system
SheerPower database interfaces
SheerPower editor
SheerPower environment
    error message
    SheerPower editor
    Tab key features
SheerPower Exact Math
SheerPower exception messages
SheerPower Internet Services (SPINS) Webserver
SheerPower keystrokes
SHEERPOWER menu item in SPDEV
SheerPower Professional Application Development
SheerPower program description
SheerPower program elements
SheerPower Program Structure
SheerPower Rapid Development Environment
    getting started
SheerPower reserved words #1
SheerPower reserved words #2
SheerPower statement - what it does
SheerPower structure
SheerPower Tag - ATTACHED attribute
SheerPower tag attributes
SheerPower Tag - AUTOSCALE attribute
SheerPower Tag - AUTOSUBMIT attribute
SheerPower tag - BACKGROUND [image] attribute
SheerPower tag - color, height, width, title attributes
SheerPower tag - default path for type attribute
SheerPower Tag in Input Dialogbox
SheerPower tag - SRC attribute
SheerPower Tag - TYPE attribute
SheerPower text windows
Shift Keystrokes
SHOW FILES command
SIN function
SINH function
SIZE function
%SIZE menu directive
SKIP function
software maintenance
SORT
    ASCENDING
    DESCENDING
SORT attribute to <th> tag in input dialogbox
SORT$ function
SORT in EXTRACT
Sort keys
SORT within EXTRACT STRUCTURE
Sorting extracted records
Sound files
SP4GL
SP4GL Console Window
    Entering multiple commands
SP4GL Console Window Commands
SP4GL.INI - editing to set logicals
SPACE$ function
%SPCODE Tag
SPDEV
    creating a new program
    deploying a program
    GOLD/O to Organize Routines
    Routine Definitions
    Routine Header Template
    Routine Template
    running a program
    Saving a program
    Using GOLD/R to make a subroutine
SPDEV - Backups
SPDEV Change System Settings
SPDEV GOLD key
SPDEV Menu Items
SPDEV - PURGE backup files
SPDEV - SheerPower Rapid Development Environment
Specific Tables of Keystroke Functions
Specify Any Root Folder
Spelling correction with the TAB key
SPINS - replace IIS
SPINS - running for the first time #1
SPINS - running for the first time #2
SPINS - specify any root folder
SPINS - specify different port to use #1
SPINS - specify different port to use #2
SPINS Webserver
SPINS Webserver Location and Directory Structure
SPINS Webserver Options
spins_webserver -? options command
SPINS_webserver test #1
SPINS_webserver test #2
%SPLIT menu directive
SPRUN files - password protect
%SPSCRIPT Tag
.SPSRC extension #1
.SPSRC extension #2
.SPSRC program extension
SQR function
SRC attribute - SheerPower tag
Starting Position in SETUP
Statement presentation
Statement spelling correction
Statements
    ADD STRUCTURE/END ADD
    ASK #chnl_num
    ASK ERRORS
    ASK KEYSTROKES
    ASK PAGESIZE
    ASK RESPONSES
    ASK/SET MARGIN #1
    ASK/SET MARGIN #2
    ASK/SET SEED
    ASK/SET SYSTEM: COMMENT #1
    ASK/SET SYSTEM: COMMENT #2
    ASK/SET SYSTEM: DIRECTORY #1
    ASK/SET SYSTEM: DIRECTORY #2
    ASK/SET SYSTEM, LOGICAL: VALUE #1
    ASK/SET SYSTEM, LOGICAL: VALUE #2
    ASK/SET SYSTEM: PROCESS #1
    ASK/SET SYSTEM: PROCESS #2
    ASK/SET SYSTEM, SYMBOL 'OS:xxx': VALUE str$
    ASK/SET SYSTEM, SYMBOL: VALUE #1
    ASK/SET SYSTEM, SYMBOL: VALUE #2
    ASK/SET WINDOW AREA #1
    ASK/SET WINDOW AREA #2
    ASK/SET WINDOW: COLUMN #1
    ASK/SET WINDOW: COLUMN #2
    ASK/SET WINDOW: CURRENT
    ASK/SET WINDOW: DATA #1
    ASK/SET WINDOW: DATA #2
    ASK/SET WINDOW: KEYMAP
    ASK/SET WINDOW: ROW #1
    ASK/SET WINDOW: ROW #2
    ASK/SET WINDOW: TYPEAHEAD #1
    ASK/SET WINDOW: TYPEAHEAD #2
    ASK/SET ZONEWIDTH #1
    ASK/SET ZONEWIDTH #2
    ASK STRUCTURE options
    ASK SYSTEM: MODE
    ASK SYSTEM: PARAMETER
    ASK SYSTEM: PROGRAM
    ASK SYSTEM: RIGHTS
    ASK SYSTEM: USER
    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 STRUCTURE
    CONTINUE in HANDLER routine
    CSET
    CSET FILL
    DATA
    DEBUG ON/OFF #1
    DEBUG ON/OFF #2
    DEBUG ON/OFF #3
    DECLARE
    DECLARE STRUCTURE
    DELAY
    DELETE STRUCTURE
    DIM
    DISPATCH
    DO in DO/LOOP
    END
    END DO
    EXCLUDE in EXTRACT STRUCTURE
    EXECUTE
    EXIT ADD
    EXIT DO
    EXIT EXTRACT
    EXIT FOR
    EXIT FOR in FOR/NEXT loop
    EXIT HANDLER in HANDLER routine
    EXIT ROUTINE
    EXTRACT STRUCTURE ... END EXTRACT
    FOR EACH ... NEXT structure
    FOR in FOR/NEXT loop
    HALT
    IF/THEN...END IF
    INCLUDE in EXTRACT STRUCTURE
    INPUT
    INPUT #chnl_num
    INPUT DIALOGBOX
    ITERATE
    ITERATE DO
    ITERATE FOR in FOR/NEXT loop
    KILL a file
    LET
    LIBRARY
    LINE INPUT #chnl_num
    LIST STATS
    LOCK/UNLOCK STRUCTURE
    LOOP in DO/LOOP
    LSET
    LSET FILL
    MESSAGE
    NEXT in FOR/NEXT loop
    OPEN #chnl_num: NAME
    OPEN file: NAME
    OPEN STRUCTURE
    OPTION BASE #1
    OPTION BASE #2
    OPTION REQUIRE DECLARE
    PASS [NOWAIT | NORETURN | WINDOW | TIMEOUT]
    PRINT
    PRINT #chnl_num
    PROGRAM
    RANDOMIZE
    READ
    REDIM
    REEXTRACT STRUCTURE ... 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 ON/OFF #1
    SET BACK ON/OFF #2
    SET #chnl_num
    SET ERROR ON/OFF #1
    SET ERROR ON/OFF #2
    SET EXIT ON/OFF #1
    SET EXIT ON/OFF #2
    SET HELP ON/OFF #1
    SET HELP ON/OFF #2
    SET SCROLL
    SET STRUCTURE options
    SET WINDOW KEYSTROKE: VALUE
    SORT in EXTRACT STRUCTURE
    STATS ON/OFF #1
    STATS ON/OFF #2
    STEP
    STOP
    TRACE ON/OFF
    WHEN EXCEPTION IN/USE/END WHEN
    WHEN EXCEPTION USE
STATISTICS feature in DEBUG system
STATS ON/OFF in debug system #1
STATS ON/OFF in debug system #2
STEP in debug system
STEP option in FOR/NEXT loop
Stock Quote sample program
STOP statement
Storing Selections from a Form into Variables
STR$ function
String data
String delimiters
String expressions - concatenated
String format characters in PRINT USING
String Manipulation Functions
String Searching and Comparing Functions
Structure
Structure references
Structure types
Structure - updating existing information
Structures
    field names
    fields
    records
Subfolders - purge backup files
Submenu indicator
Submit buttons in Dialogbox - images
Submit buttons in input dialogbox
Subroutines using GOLD/R in SPDEV
Substrings
Summary of CGI environment variables
Supported HTML Tags in Input Dialogbox
System Settings in SPDEV
SYSTEXT$
SYSTEXT$ function #1
SYSTEXT$ function #2


Previous Next Contents Index