Sheerpower^®
A Guide to the Sheerpower Language

D
Data Dictionary in SETUP
Data Entry User Interface
Data Field Description in Database SETUP
Data Field Starting Position
Data Management System
Data Set
DATA Statement
Data Table Statements
ADD TABLE ... END ADD
ASK TABLE Options
CANCEL ADD
CANCEL EXTRACT
CLOSE ALL
CLOSE TABLE
DELETE TABLE
EXCLUDE in EXTRACT TABLE
EXIT ADD
EXIT EXTRACT
EXTRACT TABLE ... END EXTRACT
FOR EACH ... NEXT Table
INCLUDE in EXTRACT TABLE
LOCK/UNLOCK TABLE
OPEN TABLE
REEXTRACT TABLE ... END EXTRACT
SET TABLE Options
SORT in EXTRACT TABLE
Data Types
Integer Number
Real Number
Data Types in SETUP
Data Types in Sheerpower
Database Backup (ARS)
Database Engines Supported
ARS #1
ARS #2
FASTFILE
Database Query Sample Program
Database Record Size
Database Scan Sample Program
Database Setup
Access Rules
Classification
Create Data File
Creating the Data File
Data Dictionary
Data Set
Data Type
Database Engine
Deleting Field Information
Description
Entering SETUP
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
Prompt Text
Properties and Procedures
Record size
Report Heading
Screen Mask
Semantics
SETUP Routine
SETUP Structure Definition
Starting Position
Structure/Table Security
Validation Rules
Variable Field Lengths
Viewing and Printing Definitions
Database Update Sample Program
DATAFILE Option in OPEN TABLE
DATATYPE - Field Definition Item
DataTypes
String
DATE Directive Used with PRINT USING
DATE Format$ Function
DATE Function
DATE$ Function
Date Functions
Date - Pivot
DAY$ Function
DAYS Function
DDE
Accessing Microsoft Excel
Accessing Microsoft Word
Syntax Errors
DDE Sample Program Using Excel
Debug
HALT
LIST
SHOW ALL
SHOW CALLS
SHOW FILES
STEP
STEP OUT
STEP OVER
Debug Comments
DEBUG ON/OFF
%DEBUG Program Directive
Debug Statement
DEBUG ON/OFF
SET/CANCEL WATCH
TRACE ON/OFF
Debug Statements
BREAK
LIST STATS
STATS ON/OFF
Debug System
Debugging and Exception Handling Functions
EXLABEL$
EXTEXT$
EXTYPE
SYSTEXT$
_DEBUG
_STATUS
_STRING
Debugging and Experimenting in Sheerpower
DECLARE
Multiple Data Types
DECLARE Statement
BOOLEAN Option
DYNAMIC Option
INTEGER Option
OBJECT Option
REAL Option
STRING Option
DECLARE TABLE
DECODE Function
Default File Location & File Type in SPDEV
DEFAULT Option in INPUT
Defining Arrays
Defining CODE and SCRIPT Areas
Defining Existing ARS File Fields
DEG Function
DELAY Option in MESSAGE Statement
DELAY Statement
Delay Statement
Mouse Usage
Delete Keystrokes
DELETE STRUCTURE
Delete TABLE
Deleting a file
Deleting Field Information in SETUP
Deploying a Program in Sheerpower
DESCRIPTION - Field Definition Item
Developing Professional Applications with Sheerpower
Development Cycle Time
DIALOGBOX Option
DIALOGBOX Statement #1
DIALOGBOX Statement #2
DIM Statement #1
DIM Statement #2
Dimensioning Arrays
Directives in INPUT DIALOGBOX
Directives in Programs
%COMPILE
%DEBUG
%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 ARS Locking Information
DISPLAY Menu Item in SPDEV
Displaying Data
Displaying Messages
Distance Calculations with GEODISTANCE$ Function
DIV0 Function
DIVISION Tag DIV INPUT DIALOGBOX
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 Language
Documenting Source Code
Double Forward Slash Comments "//"
Download Sheerpower
DTYPE Function #1
DTYPE Function #2
Duplicate Text and Code with SmartCopy
Dynamic form generation