Sheerpower^®
A Guide to the Sheerpower Language

Chapter 12
12	Sheerpower and DDE
12.0.1	Checking DDE Syntax
12.0.2	Accessing Microsoft Word Via DDE
12.1	Read/Write to the Windows Registry
Chapter 13
13	Exception Handling
13.1	CAUSE EXCEPTION
13.2	WHEN EXCEPTION IN
13.3	WHEN EXCEPTION USE
13.4	HANDLER Routine Actions
13.4.1	RETRY
13.4.2	CONTINUE
13.4.3	RESUME
13.4.4	EXIT HANDLER
Chapter 14
14	File Handling
14.1	OPEN FILE var_name: NAME ...
14.1.1	OPEN #chnl_num: NAME ...
14.1.2	Logicals
14.1.3	OPEN Options
14.1.3.1	ACCESS Option
14.1.3.2	UNFORMATTED Option
14.1.3.3	OPTIMIZE OFF Option
14.1.3.4	UNIQUE Option
14.1.3.5	LOCK Option
14.2	CLOSE #chnl_num
14.3	PRINT #chnl_num
14.4	INPUT #chnl_num: var, var...
14.4.1	Inputting multiple variables
14.5	LINE INPUT #chnl_num: str_var, str_var...
14.5.1	EOF Option
14.5.2	Multiple Variables
14.6	ASK #chnl_num:
14.6.1	ASK Options
14.7	SET #chnl_num: expr
14.7.1	SET #chnl_num: Options
14.8	Deleting Files
14.8.1	KILL
14.9	Working with Text Windows
14.10	Printing Output Using the PASS Statement
14.11	Playing WAV Files using the MEDIA Statement
Chapter 15
15	Data Table Statements
15.1	General Information
15.2	OPEN TABLE
15.2.1	ACCESS Option
15.2.2	CACHESIZE Option
15.2.3	LOCK Option
15.2.4	DATAFILE Option
15.3	CLOSE TABLE
15.4	ADD TABLE
15.4.1	CANCEL ADD
15.4.2	EXIT ADD
15.5	DELETE TABLE
15.6	LOCK | UNLOCK TABLE
15.6.1	UNLOCK TABLE: COMMIT | UNLOCK ALL: COMMIT
15.7	EXTRACT TABLE
15.7.1	INCLUDE Statement
15.7.2	EXCLUDE Statement
15.7.3	SORT Statement
15.7.4	FOR EACH/NEXT
15.7.5	EXTRACT TABLE: KEY
15.7.6	EXTRACT TABLE, FIELD: PARTIAL KEY
15.7.7	CANCEL EXTRACT
15.7.8	EXIT EXTRACT
15.7.9	REEXTRACT TABLE
15.7.10	EXTRACT TABLE: APPEND
15.8	ASK TABLE
15.8.1	ASK TABLE FIELD: item
15.8.1.1	FIELD Expressions
15.8.1.2	Item: ACCESS
15.8.1.3	Item: APPLICATION
15.8.1.4	Item: ATTRIBUTES
15.8.1.5	Item: CHANGEABLE
15.8.1.6	Item: DATATYPE
15.8.1.7	Item: DESCRIPTION
15.8.1.8	Item: HEADING
15.8.1.9	Item: HELP
15.8.1.10	Item: KEYED
15.8.1.11	Item: LENGTH
15.8.1.12	Item: NAME
15.8.1.13	Item: NULL
15.8.1.14	Item: NUMBER
15.8.1.15	Item: OPTIMIZED
15.8.1.16	Item: POSITION
15.8.1.17	Item: PRINTMASK
15.8.1.18	Item: PROMPT
15.8.1.19	Item: SCREENMASK
15.8.1.20	Item: VRULES
15.8.2	ASK TABLE: CURRENT
15.8.3	ASK | SET TABLE: DATA
15.8.4	ASK TABLE: DATAFILE
15.8.5	ASK TABLE: FIELDS
15.8.6	ASK TABLE: KEYS
15.8.7	ASK TABLE: CAPABILITY
15.8.8	ASK TABLE: EXTRACTED
15.8.9	ASK TABLE: ID
15.8.10	ASK TABLE: POINTER
15.8.11	ASK TABLE: RECORDSIZE
15.8.12	ASK TABLE: ACCESS
15.8.13	ASK | SET TABLE #string_expr . . .
15.8.14	ASK TABLE: ENGINE
15.9	SET TABLE
15.9.1	SET TABLE: CURRENT
15.9.2	SET TABLE, FIELD: KEY
15.9.3	SET TABLE, FIELD: PARTIAL KEY
15.9.4	SET TABLE: ID
15.9.5	SET TABLE: POINTER
15.9.6	SET TABLE: EXTRACTED 0
15.10	Update a Table Record