Multiple database engines (record management systems) can be used with Sheerpower. The following database engines are currently supported:

• ARS
• FASTFILE

The SETUP routine tells Sheerpower where data files are located and what record management systems are used. Once you have defined your tables using SETUP, you can use Sheerpower's table statements to manipulate the data.

For detailed information on Sheerpower interfaces to the various database engines and how to use SETUP, refer to Chapter 16, Database Setup in this manual.

Sheerpower Rapid Development Environment (SPDEV) has many default keystrokes mapped to simplify and speed up program creation and file editing. A 'mapped keystroke' means that the regular function of a certain key may not perform the same function while in Sheerpower Rapid Development Environment. For example, KP0 - means the number 0 (zero) in the numeric keypad of a keyboard. KP stands for keypad. In other programs, KP0 will print a 0 (zero). In SPDEV, KP0 moves the cursor to the beginning of the next line. At the end of a file, it will create a new line at the bottom of the file.

The keystrokes are grouped in tables by usage for quick reference.

F.0.1 GOLD Key

The GOLD Key referred to in these tables is a special key used to create many of the keystrokes within SPDEV. Both the [Esc] (escape key - top left corner of the keyboard) and the [Num-Lock] (numbers lock key in the numeric keypad) are GOLD keys in Sheerpower Rapid Development Environment.

To use the GOLD key, press the GOLD key, let go, then continue with the rest of the keystroke to complete the function.

For example, to use gold/F3 to bring up the FIND dialog box, you would press once on a GOLD key, either the escape key or the num-lock key. Let go and look in the bottom right hand corner of the SPDEV window. Sheerpower tells you if your GOLD key is activated by highlighting a small square in the bottom frame on the right side in black with gold letters that say 'Gold'.

Gold|CAP|NUM|OVR

Now that the GOLD key is activated, press [F3] to complete the keystroke. The FIND dialog box will pop open on the screen.

When using the Ctrl or Alt in SPDEV keystrokes, keep the Ctrl or Alt key depressed while completing the keystroke. Keystrokes are shown in the order of key pressed.

In SPDEV you can custom map any keystroke to suit your programming and editing style. For details on custom keymapping in SPDEV, see Section H.6.3, Keystroke Function Mappings Option.

By default, keypad editing is turned on---where the numeric keypad is used for rapid editing. To turn off this high-speed editing feature:

• In SPDEV toolbar click on Options.
  
• Select "Change System Settings".
  
• Then select the checkbox beside "Disable Keypad Editing"

1. Section F.1, Most Popular Keystrokes

2. Section F.2, Programming Keystrokes

3. Section F.3, Keystroke Combinations

4. Section F.4, Editing Keystrokes

5. Section F.5, Keystrokes For Movement Within a File

6. Section F.6, Search, Find and Replace Keystrokes

7. Section F.7, Keypad Editing Keystrokes

8. Section F.11, Alt Keystrokes

9. Table F-14, Ctrl Keystrokes

10.Table F-15, F Keystrokes

11. Section F.12, Shift Keystrokes

12. Section F.13, Learn and Macros Keystrokes

13. Section F.14, All Keystrokes

Certain keystrokes are used more often than others. The following table contains the most popular keystrokes for Sheerpower users.

Table F-1 Most Popular SPDEV Keystrokes

Keystroke	Function Performed
ESCAPE	GOLD key
NUMLOCK	GOLD key
gold/alt/n	bring up NEW FILE dialog box
gold/alt/o	bring up OPEN FILE dialog box
gold/alt/p	purge previous file versions
gold/alt/l	launch a new instance of SPDEV
gold/alt/4	launch console window
gold/alt/s	save current file
gold/f	Program file - wraps long lines of code correctly at the right-margin and inserts "&" at the end of the wrapped line of code. Code is indented accordingly.
gold/f	Text file - wrap and fill selected text. If no text is selected, it defaults to the 'current paragraph'.
gold/KP Enter	bring up the REPLACE dialog box
gold/F3	bring up FIND dialog box
gold/KP *	bring up FIND dialog box
F3	find next
F11	go to definition-place the cursor on a reference to a routine, then press F11 to go directly to that routine.
F12	show definition-place cursor on a reference to a routine, then press F12 to display the contents of the routine header in a new window.
KP *	find next
ctrl/g	find next
ctrl/m	insert/remove bookmark
ctrl/n	move cursor to next bookmark
ctrl/p	move cursor to previous bookmark
ctrl/a	select all
ctrl/KP +	cut current character
gold/ctrl/KP +	uncut current character [paste]
KP 5+	cut current word
gold/KP +	uncut current word [paste]
KP 4	select current line
gold/KP 4	select current paragraph
ctrl/c	copy (end selection)
ctrl/x	cut selection
ctrl/v	paste
gold/KP 6	paste
delete	delete current selection or current character
gold/end	delete from cursor to end of line
ctrl/u	delete from cursor to beginning of line
gold/home	delete from cursor to beginning of line
gold/F2	delete from cursor to end of word [including any white space]; deleted characters saved in word paste buffer
ctrl/y	redo
ctrl/z	undo
ctrl/r	restore previous selection
alt/r	runs the current program
gold/KP 8	Program file - wraps long lines of code correctly at the right-margin and inserts "&" at the end of the wrapped line of code. Code is indented accordingly.
gold/KP 8	Text file - wrap and fill selected text. If no text is selected, it defaults to the 'current paragraph'.
home	move cursor to the beginning of current line
ctrl/e	move cursor to end of line (or end of next line if already at end of line)
end	move cursor to end of line (or beginning of line if already at end of line, and visa versa)
gold/page down	move cursor to bottom of file
gold/page up	move cursor to top of file
left arrow	move cursor left one character
ctrl/left arrow	move cursor left one word
right arrow	move cursor right one character
ctrl/right arrow	move cursor right one word
down arrow	move cursor down one line
alt/down arrow	prompts for # of lines to move down; moves cursor down that # of lines
up arrow	move cursor up one line
alt/up arrow	prompts for # of lines to move up; moves cursor up that # of lines
gold/down arrow	convert selection to lower case, skips quoted text
gold/up arrow	convert selection to upper case, skips quoted text

These keystrokes are extremely helpful and time-saving particularly for programmers.

Table F-2 Programming Keystrokes

Keystroke	Function Performed
gold/alt/n	bring up NEW FILE dialog box
gold/alt/o	bring up OPEN FILE dialog box
gold/p	generate a program template
gold/r	generate a routine template
gold/o	organize routines within source code
gold/d	document a routine in a program
gold/a	align the "=" and ":" in a group of variable assignments
gold/c	generate debug comment line of !++ xxx date
gold/forward slash	comment/uncomment the selected text or current line
gold/f	Program file - wraps long lines of code correctly at the right-margin and inserts "&" at the end of the wrapped line of code. Code is indented accordingly.
gold/f	Text file - wrap and fill selected text. If no text is selected, it defaults to the 'current paragraph'.
alt/i	open .SPINC (include) files
gold/alt/l	launch a new instance of SPDEV
gold/alt/4	launch console window
gold/alt/z	save open files and exit SPDEV
gold/F3	bring up FIND dialog box
gold/KP *	bring up FIND dialog box
F3	find next
F11	go to definition-place the cursor on a reference to a routine, then press F11 to go directly to that routine.
F12	show definition-place cursor on a reference to a routine, then press F12 to display the contents of the routine header in a new window.
KP *	find next
ctrl/f	brings up the FIND dialog box
ctrl/m	insert/remove bookmark
ctrl/n	move cursor to next bookmark
ctrl/p	move cursor to previous bookmark
ctrl/enter	activates the SmartCopy programming keystroke. See Section O.1.1, Smart Copy and Paste (Programming Keystroke) for more details and examples
gold/l	start/stop recording macro
gold/n	run the macro associated with the number (n = number)
alt/r	runs the current program
F9	expansion key
KP /	expansion key
KP 0	move cursor to the beginning of the next line. If at EOF, a new line is started.
gold/KP 0	insert a blank line before the current line; moves cursor to the blank line.
gold/KP 2	delete from cursor to end of line
gold/kp 8	Program file - wraps long lines of code correctly at the right-margin and inserts "&" at the end of the wrapped line of code. Code is indented accordingly.
gold/kp 8	Text file - wrap and fill selected text. If no text is selected, it defaults to the 'current paragraph'.
gold/home	delete from cursor to beginning of line
gold/page down	move cursor to bottom of file
gold/page up	move cursor to top of file
alt/down arrow	prompts for # of lines to move down; moves cursor down that # of lines
alt/up arrow	prompts for # of lines to move up; moves cursor up that # of lines
gold/alt/s	save current file