SheerPower^® 4GL
A Guide to the SheerPower Language

T
TAB function
TAB in PRINT statement
TAB key - usage
completing commands
correct spelling
expanding abbreviations
TAB key with input screen
TABLE DATA
TABLE DATA tag attributes
TABLE HEADER tag
TABLE ROW tag
TABLE ROW tag attributes
TABLE TAG ATTRIBUTES
TABLE TAGS
Table - updating existing information
TAN function
TANH function
tcp://
TCP/IP and UDP Protocols
Temp folders and Security in SheerPower 4GL
Test SPINS_webserver #1
Test SPINS_webserver #2
Testing CGI Interface
Testing the CGI Interface
TEXT FORMATTING TAGS
Text windows
TEXTAREA tag
TEXTAREA Tag Attributes
textwindow output
<th>...</th>
TIME(5) function
TIME directive used with PRINT USING
TIME function
TIME$ function #1
TIME$ function #2
TIMEOUT option in INPUT
TIMEOUT option to PASS Statement
%TITLE menu directive
TRACE ON/OFF
Tracing Application Logic Flow
Transcendental Functions
Translate
TRIM$ function
Trim leading spaces
Troubleshooting the CGI Interface
TRUE/FALSE condition
BOOLEAN variables
TRUE function
TRUNCATE function
TYPE attribute DEFAULT Path
Type attribute - SheerPower tag
U
UBOUND function
UCASE directive used with PRINT USING
UCASE$ function
UDP and TCP/IP Protocols
Understanding variable namespace when using routines
UNFORMATTED option in OPEN #chnl_num
UNIQUE option in OPEN #chnl_num
Unlock a structure record
UNLOCK ALL: COMMIT
UNLOCK ALL Statement
UNLOCK STRUCTURE: COMMIT
UNORDERED LIST tag
UNQUOTE$ function
UNTIL option in DO/LOOP #1
UNTIL option in DO/LOOP #2
UNTIL option in DO/LOOP #3
UNTIL option in DO/LOOP #4
UP-arrow during input
Updating a Structure/Table
URLDECODE$ function
URLENCODE$ function
Use of Parenthesis
USE with WHEN EXCEPTION IN
User conventions
Using Commands in SP4GL Console Window
USING option in PRINT statement
Using the SP4GL Console Window
Utilizing data from the Internet
V
VAL function
VALID function
VALID option in INPUT
Validating data when inputting
Validation rules
ALLOW
CHARACTERS
CODE
DATE
DATE DMONCY
DATE DMONY
DECIMALS
DIGITS
DISALLOW
EXPRESSION
FILTER
CHANGE
LCASE$
LTRIM$
REMOVE
REPLACE
RESTORE
RTRIM$
TRIM$
UCASE$
FULLTIME
INTEGER
INTEGER WORD
LCASE
LENGTH
LETTERS
MAXLENGTH
MENU
MINLENGTH
NOCHARACTERS
NUMBER
PATTERN
PRINTMASK
REQUIRED
ROUTINE
UCASE
VRULES
YES/NO
Validation Rules in SETUP
Variable Data-inserting into a form
Variable Field Lengths in SETUP
Variable namespace
variable namespace in routines
Variables
private in routines #1
private in routines #2
Variables - description
Variables, private - passing parameters
Variables - storing dialogbox selections
VRULES - field definition item
W
Waiting for CGI Requests
Waiting for CGI requests
Web Scripting
Chapter Overview
Defining CODE and SCRIPT Areas
Embed code inside a script area
How to invoke a SheerPower script program in the browser
%INCLUDE Tag
%ONCE Tag
SheerPower Code Areas
%SPSCRIPT Tag
Web Scripting Program Examples
Web Scripting Tags
%SPCODE
Webserver CGI Interface
Webserver Environment Variables
Webserver - SPINS
What is a 4GL?
WHEN EXCEPTION IN
WHEN EXCEPTION USE
WHILE option in DO/LOOP #1
WHILE option in DO/LOOP #2
WHILE option in DO/LOOP #3
WHILE option in DO/LOOP #4
%WIDTH menu directive
WINDOW menu item in SPDEV
WINDOW option of PASS
Windows languages
Windows library
Word - accessing via DDE
Working with text windows
WRAP$ function
Wrapped text example
Write and Read Binary Files
Writing to a file
WWWROOT - specify any root folder with SPINS
X
XLATE$ function
Z
ZIPCODE directive used with PRINT USING
Zonewidth in SET MARGIN
_
_BACK in SET BACK OFF
_BACK in SET BACK ON
_BACK system function
_CHANNEL system function #1
_CHANNEL system function #2
_DEBUG system function
_ERROR in SET ERROR OFF
_ERROR in SET ERROR ON
_EXIT in SET EXIT OFF
_EXIT in SET EXIT ON
_EXIT internal variable
_EXIT system function
_EXTRACTED system function
_HELP in SET HELP OFF
_HELP in SET HELP ON
_HELP system function
_REPLY system function
_STATUS system function
_STRING system function #1
_STRING system function #2
_TERMINATOR system function #1
_TERMINATOR system function #2