SheerPower^® 4GL
A Guide to the SheerPower Language

D
Data dictionary
Data-inserting variable data into a form
Data management system
Data Record Lookups and Updating the Record
Data Set
Data Source Setup - ODBC
DATA statement
Data structure statements
ADD STRUCTURE/END ADD
ASK STRUCTURE options
CANCEL ADD
CANCEL EXTRACT
CLOSE ALL
CLOSE STRUCTURE
DELETE STRUCTURE
EXCLUDE in EXTRACT STRUCTURE
EXIT ADD
EXIT EXTRACT
EXTRACT STRUCTURE ... END EXTRACT
FOR EACH ... NEXT structure
INCLUDE in EXTRACT STRUCTURE
LOCK/UNLOCK STRUCTURE
OPEN STRUCTURE
REEXTRACT STRUCTURE ... END EXTRACT
SET STRUCTURE options
SORT in EXTRACT STRUCTURE
Data Type in SETUP
Data types
integer number #1
integer number #2
real number #1
real number #2
string #1
string #2
Database access
Database Engine
Database engine
Database engines - supported #1
Database engines - supported #2
Database engines - supported #3
Database engines - supported #4
ARS #1
ARS #2
FASTFILE #1
FASTFILE #2
ODBC #1
ODBC #2
Database Query sample program
Database sample program
Database Setup
DATAFILE option in OPEN STRUCTURE
DATATYPE - field definition item
Date and Time Functions
DATE directive used with PRINT USING
DATE format with FORMAT$
DATE function
DATE$ function
Date - Pivot
DAY$ function
DAYS function
DDE - accessing Microsoft Word, examples
DDE sample program using Excel
DDE Syntax Errors
Debug
Comments
Debug Comments in Programs
Debug Comments in SPDEV
DEBUG ON/OFF #1
DEBUG ON/OFF #2
DEBUG ON/OFF #3
Debug statements
BREAK
DEBUG ON/OFF
LIST STATS
STATS ON/OFF
STEP
TRACE ON/OFF
Debug system
Debugging and Exception Handling Functions
DECLARE
multiple data types
DECLARE statement #1
DECLARE statement #2
BOOLEAN option
DYNAMIC option
INTEGER option
OBJECT option
REAL option
STRING option
DECLARE STRUCTURE
DECODE function
Default file extension - .SPSRC
DEFAULT option in INPUT
Default path for type=open
Defining arrays
Defining CODE and SCRIPT Areas
DEG function
DEGREE function
DELAY option in MESSAGE statement
DELAY statement
Delete Keystrokes
DELETE STRUCTURE
Delete structure record
Deleting a file
Deploying a program - SPRUN
Deploying a SheerPower Program
DESCRIPTION - field definition item
Developing Professional Applications with SheerPower
Development cycle time
Dialogbox
Dialogbox - Data Record Lookups and Updating the Record
Dialogbox Image Submit Buttons
Dialogbox Option
Dialogbox Statement
Dialogbox statement
Dialogbox - storing selections into variables
DIM statement
dim statement
Dimension array
Directives in Input Dialogbox
Directives in programs
%COMPILE
%INCLUDE
%INCLUDE CONDITIONAL
%MESSAGE
%MESSAGE ERROR
Directives used in menus
Directives used with PRINT USING
Disable Keypad Editing #1
Disable Keypad Editing #2
DISPATCH statement
DISPLAY menu item in SPDEV
Displaying Complex Expression Results
Displaying data
Displaying messages
DIV0 function
DIVISION tag
DNS Lookups using ASK SYSTEM, SYMBOL
DO...END DO loop
DO loops
DO LOOPS
UNTIL option
WHILE option
DO statement in DO/LOOP
Documentation
A Guide to the SheerPower 4GL Language
SheerPower Coding Standards
Double forward slashes with comments
DTYPE function #1
DTYPE function #2
Dynamic form generation
E
EDIT$ function
EDIT menu item in SPDEV
Edit string
Editing input response
Editing Keystrokes
Editor - SheerPower
ELEMENT$ function
ELEMENTS function
ELSE option in IF/THEN
ELSEIF option in IF/THEN
Email sending with SheerPower
Embedded Code for CGI Symbol Lookups
Embedding Script Areas in Code Areas with %INCLUDE
Embedding SheerPower Code Inside a Script Area
EMPHASIZED tag
ENCODE$ function
END ADD
END DO statement
END EXTRACT with EXTRACT STRUCTURE
END HANDLER with HANDLER
END IF in IF/THEN statement
END IF statement in IF/THEN
END statement
End User Interface Functions
END WHEN with WHEN EXCEPTION IN/USE
Engines - database interfaces
Enter key with INPUT SCREEN
Enter License Key
Entering SETUP
Environment Variables
ALL_HTTP
ALL_RAW
APPL_MD_PATH
AUTH_PASSWORD
AUTH_TYPE
AUTH_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH
CONTENT_TYPE
HTTPS
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
HTTP_ACCEPT
HTTP_ACCEPT_ENCODING
HTTP_ACCEPT_LANGUAGE
HTTP_CONNECTION
HTTP_COOKIE
HTTP_HOST
HTTP_REFERER
HTTP_USER_AGENT
INSTANCE_ID
INSTANCE_META_PATH
LOGON_USER
PATH_INFO
PATH_TRANSLATED
QUERY_STRING
REMOTE_ADDR
REMOTE_HOST
REMOTE_USER
REQUEST_METHOD
SCRIPT_NAME
SERVER_NAME
SERVER_PORT
SERVER_PORT_SECURE
SERVER_PROTOCOL
SERVER_SOFTWARE
URL
Environment variables for CGI - summary
EOF option with LINE INPUT
ERASE in PRINT statement
ERASE option in INPUT
Error counter
%error directive - input dialogbox statement
Error message
Error messages
compile errors
exceptions
Error messages when passing routine parameters
ERROR option in MESSAGE statement
Errors and Exceptions
Console Window
Esc during input
escape key during input
Escape key with input screen
EVAL function
Evaluating expressions
Evaluation order
EVAL_HANDLER Program - How it works
eval_handler.spsrc - how it works
Exact Math
Exception handling
attached handler
CAUSE EXCEPTION
CONTINUE
CONTINUE in HANDLER routine
detached handler
EXIT HANDLER
EXIT HANDLER in HANDLER routine
EXLABEL$
EXTEXT$
EXTYPE
RESUME in HANDLER routine
RETRY
RETRY in HANDLER routine
SYSTEXT$
WHEN EXCEPTION IN/USE/END WHEN
WHEN EXCEPTION USE
Exception messages
Exclamation point with comments
EXCLUDE in EXTRACT
EXCLUDE within EXTRACT STRUCTURE
Excluding extracted records
Execute library routines
EXECUTE statement
EXIT ADD
EXIT DO statement
EXIT during input
EXIT EXTRACT
EXIT FOR
EXIT FOR statement in FOR loop
EXIT HANDLER statement in HANDLER routine
EXIT ROUTINE statement
Exit when adding a structure record
EXLABEL$
EXLABEL$ function
EXP function
Expanding abbreviations with the TAB key
Expansions in SPDEV
Expression evaluation
Expressions - description
Expressions - displaying results
EXTEXT$
EXTEXT$ function
Extract a range of keys
Extract criteria
EXTRACT STRUCTURE: APPEND #1
EXTRACT STRUCTURE: APPEND #2
EXTRACT STRUCTURE ... END EXTRACT
EXTRACT STRUCTURE, FIELD: PARTIAL KEY
EXTRACT STRUCTURE: KEY #1
EXTRACT STRUCTURE: KEY #2
Extracting records from a structure
EXTYPE
EXTYPE function