Starting ViewStore

To enter ViewStore from VIEW ViewSheet, BASIC or another language, type
*STORE and press RETURN

Command screen commands

(Minimum abbreviations shown in brackets)

*BASIC 		Switches computer to BASIC
(*B.)

*CAT 		Displays files on current drive
(*.)

*DELETE filename 	Deletes the specified file
(*DE.)

ESCAPE 		Switches between the command sereen and 		the data screen

LIST 		Lists the field names ofthe currently loaded
(LI) 		database

LOAD filename 	Loads the database D.filename and the
(L)		format file F.filename

LOAD datafile formatfile 	Loads the database file D.datafile and the
		format file F.formatfile

LF filename 		Loads the formatfile F.filename

MODE number 	Switches to the specified screen mode
( M )

NEW 		Closes all files and reinitialises ViewStore

PREFIX 		Displays the currently set prefixes
(PRE)

PREFIX letter text 	Sets the prefix for the file type specified by 		the letter to text

PRINTER filename 	Loads a printer driver from the specified file
(PRINTE)

SF filename 		Saves the current format in file F.filename

*SHEET 		Switches computer to ViewSheet
(*SHE.)

*SPELL 		Switches computer to ViewSpell
(*SPE.)

UTILITY utilityname 	Enables you to run the named utility
(U)

*WORD 		Switches computer to VIEW
(*W.)

Note that filing system commands such as *COPY and *COMPACT and operating system commands such as *TV and *FX can all be used in the command screen.

Utilities

 CONVERT 	Builds a new database from the eurrent database

 INDEX 	Builds a new index for the current database

 LABEL 	Creates a label for each record you select from
	the current database or from a select file

 LINK 	Creates a ViewSheet linking file with an entry
	for each record you select from the current
	database or from a seleet file

MACRO 	Creates a VIEW macro call for eaeh record you
	select from the current database or from a seleet
	file.

REPORT 	Creates a report with an entry for each record
	you select from the current database or from a
	select file.

SELECT 	Select sorts and lists records from the current
	database

SETUP 	Creates new database, format and index files or
	a report definition file

Function keys

f0 DATA 		Switches to the data screen

SHIFTf0 CARD 	Switches to card layout editor
LAYOUT

f1 RECORD FORMAT	 Switches to record format

SHIFT f1 DATABASE 	Switches to database header
HEADER

f2 CHANGE DISPLAY	Switches between spreadsheet display and 		card display

SHIFT f2 CURSOR	Switches off/on locking ofcursor to same LOCK		field when moving between records

f3 DELETE END OF 	Deletes all characters from character cursor
FIELD 		position to end of current field

f4 BEGINNING OF 	Moves character cursor to beginning
FIELD		of current field

f5 END OF FIELD 	Moves character cursor to end of current 		field

f6 INDEX FIELD 	Displays records indexed by selected field

f7 LOCATE 		Searches the records in the order of the 		current index to locate the specified entry If 		the specified entry does not exist the search 		stops on the next entry

f8 INSERT 		Inserts a character space at the character CHARACTER 	cursor position

f9 DELETE 		Deletes character at character cursor
CHARACTER	position

SHIFT f9 DELETE 	Deletes record at field cursor position
RECORD

Cursor movement

 	Moves field cursor to next field

SHIFT 	Moves field cursor to end of record

CTRL 	Moves character cursor to uext character

 	Moves field cursor to previous field

SHIFT  	Moves field cursar to beginning of record

CTRL  	Moves character cursor to previous 			character

 	Moves field cursor to next record

SHIFT  	Moves field cursor down one screenful of records

CTRL 	Moves field cursor to end of file

 	Moves field cursor to previous record

SHIFT  	Moves field cursor up one screenful of records

CTRL  	Moves field cursor to beginning of file

Other data sereen key commands

DELETE 	Deletes character to left of character cursor

ESCAPE 	Switches between data screen and command
	screen

Data display  flags

L 	Field cursor is locked to current field when
	moving to another record

U 	Field cursor is unlocked ie returns to field 1
	when moving to another record

Space 	Number of bytes remaining to type in the
	current record

Record format entries

Note that in the record format and database header sections the default values are shown first in each case

 Field name

Name displaved at the top of the field in the spreadsheet display and the left of  the field in the card display

 Wi(dth)

Copyright Acornsoft Limited SBB27 R

 Number of characters of field entry displayed

 T(ype)

 A 	Alphanumeric characters
 T 	Text characters
 N 	Numbers only
 D 	European dates only (ie D/M/Y)
 M 	American dates only (ie M/D/Y)
 
 S(croll)

 Y 	Entries can scroll in column
 N 	Entries cannot scroll

 Alphanumeric and text scroll by default; datesand numbers do not

  D(ecimal places)

Blank	 Numbers displayed as entered
n 	Number of decimal places to which numbers
 	displayed

  Low limit

Lowest value accepted in field

 High limit

Highest value accepted in field

  I(ndex)

N 	No index is maintained for this field
Y 	Updateable index maintained for this field
R 	Read-only index can exist for this field

 Ke(y width)

Number of characters of each entry stored in index; essential if I=Y or R

 Index name

 Name of index file; essential if I= Y or R

 Prompt

 Message displayed on line 3; if left blank, field name displayed

 Value list

 List of permitted entries in field
Database header entries

 Title

 Title shown at top of data display

 Display mode

S 	Database shown in spreadsheet display when
 	first loaded
C 	Database shown in card display when first
 	loaded

 Record size

Blank 	20 extra bytes of disc space saved for each record

+n 	n extra bytes of disc space saved for each record

n 	Exactly n hytes ofdisc spacesaved for each
 	record

 Order field

Blank 	Database ordered by entry when first loaded
 	field name. Database ordered by this field when
	first loaded

 Screen mode

Blank 	Database displayed in current screen mode
n 	Database displayed in screen mode n

Layout editor key command

COPY 	Mark or move field

Wildcards

? 	matches any single character
* 	matches any number ofcharacters (including
	none)

Both ?  and * can he used to match field entries