SheerPower^® 4GL
A Guide to the SheerPower Language

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 #chnl_num: NAME ...
14.1.1	OPEN FILE num_var: 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 Media Files using the MEDIA Statement
Chapter 15
15	Data Structure Statements
15.1	General Information
15.2	OPEN STRUCTURE
15.2.1	ACCESS Option
15.2.2	LOCK Option
15.2.3	DATAFILE Option
15.3	CLOSE STRUCTURE struc_name
15.4	ADD STRUCTURE
15.4.1	CANCEL ADD
15.4.2	EXIT ADD
15.5	DELETE STRUCTURE
15.6	LOCK | UNLOCK STRUCTURE
15.6.1	UNLOCK STRUCTURE: COMMIT | UNLOCK ALL: COMMIT
15.7	EXTRACT STRUCTURE
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 STRUCTURE: KEY
15.7.6	EXTRACT STRUCTURE, FIELD: PARTIAL KEY
15.7.7	CANCEL EXTRACT
15.7.8	EXIT EXTRACT
15.7.9	REEXTRACT STRUCTURE
15.7.10	EXTRACT STRUCTURE: APPEND
15.8	ASK STRUCTURE
15.8.1	ASK STRUCTURE 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 STRUCTURE: CURRENT
15.8.3	ASK STRUCTURE: DATAFILE
15.8.4	ASK STRUCTURE: FIELDS
15.8.5	ASK STRUCTURE: KEYS
15.8.6	ASK STRUCTURE: CAPABILITY
15.8.7	ASK STRUCTURE: EXTRACTED
15.8.8	ASK STRUCTURE: ID
15.8.9	ASK STRUCTURE: POINTER
15.8.10	ASK STRUCTURE: RECORDSIZE
15.8.11	ASK STRUCTURE: ACCESS
15.8.12	ASK | SET STRUCTURE #string_expr . . .
15.8.13	ASK STRUCTURE: ENGINE
15.9	SET STRUCTURE
15.9.1	SET STRUCTURE: CURRENT
15.9.2	SET STRUCTURE, FIELD: KEY
15.9.3	SET STRUCTURE, FIELD: PARTIAL KEY
15.9.4	SET STRUCTURE: ID
15.9.5	SET STRUCTURE: POINTER
15.9.6	SET STRUCTURE: EXTRACTED 0
15.10	Updating a Structure