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