ÒÕÎ ÆILE 1.0
ÂY ÄAVID ÄARUS
Ã-64 OR Ã-128, PRINTER OPTIONAL

ÒÕÎ ÆÉÌÅ 1.0 IS A DATABASE PROGRAM FOR THE Ã-64 AND Ã-128 THAT'S DESIGNED TO DO ALL THE MANAGEMENT TASKS INVOLVED IN KEEPING RECORDS SUCH AS MAILING LISTS AND INVENTORIES. ÔHE PROGRAM REQUIRES A Ã-64 OR Ã-128 AND A 1541, 1571 OR 1581 DISK DRIVE. Á PRINTER IS OPTIONAL.

ÁFTER SOME SET-UP TIME, THE MAIN MENU SCREEN APPEARS. ÔHE WORK AREA IS IN THE TOP 22 LINES OF THE SCREEN, WITH PROGRAM AND DATABASE IDENTIFICATION NEXT, FOLLOWED BY THE MAIN MENU COMMAND LINE AND A MESSAGE LINE.

ÔHE COMMAND LINE OFFERS SIX OPTIONS: ÃLOSE, ÅDIT, ÎEW, ÏPEN, ÕTILS AND EØIT. ÔO SELECT A COMMAND, EITHER PRESS THE CAPITALIZED LETTER IN THE COMMAND, OR USE THE RIGHT-LEFT CURSOR KEY TO HIGHLIGHT THE COMMAND, THEN PRESS RETURN.

ÔHERE ARE SOME RESTRICTIONS: ÙOU CAN'T CLOSE OR EDIT A DATABASE OR EXECUTE THE ÐRINT, ÓEQ OR ÕSR COMMAND UNLESS YOU'VE OPENED A DATABASE FIRST. ÁLSO, YOU CAN'T OPEN MORE THAN ONE DATABASE AT A TIME, AND YOU CAN'T CREATE A NEW DATABASE OR EXIT THE PROGRAM IF A DATABASE IS OPEN.

ÔHE ÎEW COMMAND CREATES A NEW DATABASE FORM. ÙOU'LL BE PROMPTED TO ENTER A FILENAME FROM ONE TO 14 CHARACTERS LONG, AND THE PROGRAM WILL AUTOMATICALLY GIVE THE FILENAME A .F EXTENSION. (ÄON'T INCLUDE THE EXTENSION WHEN YOU TYPE IN THE FILENAME.)

ÉN THE FIRST 22 LINES OF THE SCREEN, YOU CAN DEFINE AND FILL UP TO 30 FIELDS, EACH HAVING A MAXIMUM LENGTH EQUAL TO THE SCREEN WIDTH MINUS 1--THAT IS, EITHER 39 OR 79 CHARACTERS. ÔHE TOTAL LENGTH OF ALL FIELDS IN THE RECORD CAN BE UP TO 254 CHARACTERS, NOT INCLUDING FIELD NAMES. ÁS YOU TYPE IN TEXT, USE THE DELETE KEY TO CORRECT MISTAKES.

ÔO DEFINE A FIELD, TYPE ITS NAME (SUCH AS ÌÁÓÔ ÎÁÍÅ OR ÓÔÒÅÅÔ). ÔO DEFINE THE LENGTH OF THE FIELD, PRESS CONTROL/Æ TO MARK ITS START, PRESS THE SPACE BAR AS MANY TIMES AS YOU WANT AND PRESS CONTROL/Æ AGAIN TO MARK THE END. ÁS YOU DO THIS, YOU'LL NOTICE A FIELD-LENGTH COUNTER AND A TOTAL-RECORD-LENGTH COUNTER AT THE BOTTOM OF THE SCREEN. ÙOU CAN USE THE DELETE KEY TO SHORTEN A FIELD AS YOU'RE DEFINING IT, BUT YOU CAN'T USE IT TO ERASE THE FIELD NAME. ÔO DO THAT, YOU MUST PRESS CONTROL/Ä TO BLANK THE LINE OUT. ÔHE TOTAL RECORD LENGTH WILL BE ADJUSTED ACCORDINGLY.

ÁNY TIME YOU PRESS THE ENTER KEY ON A LINE, THE PART OF THE LINE THAT ISN'T HIGHLIGHTED BECOMES THE NEW CONTENT OF THAT LINE AND THE HIGHLIGHTED REGION BECOMES BLANK. ÆOR THIS REASON, USE THE CURSOR KEYS TO BYPASS LINES YOU'VE ALREADY EDITED AND WISH TO KEEP AS THEY ARE.

×HEN YOU'RE SATISFIED WITH THE LAYOUT OF THE LINE, PRESS RETURN FOR THE COMPUTER TO ACCEPT IT. ÉF YOU PRESS THE CURSOR UP-AND-DOWN KEY WITHOUT PRESSING RETURN, THE LINE WON'T BE ACCEPTED.

ÔO ACCEPT THE ENTIRE FORM ON THE SCREEN, PRESS THE RUN-STOP KEY IN 64 MODE OR THE ESCAPE KEY IN 128 MODE. ÔHE CURRENT FIELD WILL BE HIGHLIGHTED, AND THE FOLLOWING LIST OF FIELD TYPES WILL APPEAR AT THE BOTTOM OF THE SCREEN: ÁLPHA, ËEY, ÎUM AND ÓPECIAL. ÙOU'LL BE PROMPTED TO CHOOSE A TYPE FOR EACH OF THE FIELDS IN THE FORM BY PRESSING THE CAPITALIZED LETTER OF YOUR CHOICE.

ÙOU CAN SELECT THE ËEY ATTRIBUTE ONLY ONCE, AND IT SHOULD BE ASSIGNED TO THE FIELD THAT BEST DISTINGUISHES RECORDS FROM EACH OTHER, SUCH AS RECORD NUMBER, EMPLOYEE ÉÄ NUMBER OR INVENTORY NUMBER. ÉF YOU DON'T SPECIFY A KEY FIELD, THE PROGRAM WILL AUTOMATICALLY ASSIGN THE FIRST FIELD IN THE DATABASE TO THAT PURPOSE. ÏTHER FIELDS CAN BE ASSIGNED ONE OR MORE OF THE OTHER TYPES--ÁLPHA, ÎUM AND ÓPECIAL. ÙOU CAN CANCEL A FIELD-TYPE SELECTION FOR THE CURRENT FIELD BY PRESSING THE CAPITALIZED LETTER AGAIN.

ÁLPHA FIELDS CAN CONTAIN UPPER- AND LOWERCASE LETTERS Á-Ú AND SPACES. ÎUM FIELDS CAN CONTAIN ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 AND SPACES. ÓPECIAL FIELDS CAN CONTAIN ! # $ % & ' ( ) * +, - . / : ; < > = ? @ [ ] ^ _ \ AND SPACES. ÏNCE YOU'VE SET THE TYPES FOR THE CURRENT FIELD, PRESS RUN-STOP IN 64 MODE OR ESCAPE IN 128 MODE TO CONFIRM THEM AND GO ON TO THE NEXT FIELD. ×HEN YOU'VE SPECIFIED A TYPE FOR EVERY FIELD, THE FORM WILL BE SAVED TO DISK AND YOU'LL RETURN TO THE MAIN MENU.

ÔHE ÏPEN COMMAND ACCESSES A PARTICULAR DATABASE AND READS ITS FORM AND INDEX INTO MEMORY. ÁFTER YOU CHOOSE ÏPEN AT THE MAIN MENU, ENTER THE NAME OF THE DATABASE YOU WANT. (ÁGAIN, DON'T INCLUDE THE EXTENSION ON THE FILENAME.) ÔHE FIRST TIME YOU OPEN A DATABASE, YOU MUST ESTIMATE THE NUMBER OF RECORDS YOU'LL WANT TO PUT IN THE FILE, SO DISK SPACE CAN BE ALLOCATED. ÔHIS ESTIMATE BY NO MEANS LIMITS THE NUMBER OF RECORDS YOU CAN ENTER, AS LONG AS YOU DON'T EXCEED THE MAXIMUM OF 1000 RECORDS IN 64 MODE OR 2000 IN 128 MODE.

ÁFTER YOU'VE ENTERED YOUR ESTIMATE, AN INDEX FILE (WITH A .I EXTENSION ON THE FILENAME) WILL BE CREATED, ALONG WITH A RELATIVE DATA FILE (WITH A .D EXTENSION).

ÔHE ÅDIT COMMAND LETS YOU ACCESS, BROWSE THROUGH AND UPDATE RECORDS. ×HEN YOU ENTER ÅDIT MODE, THE CURSOR APPEARS ON THE FIRST FIELD IN THE FORM. ÕSE THE UP-AND-DOWN CURSOR KEYS TO MOVE FROM FIELD TO FIELD WITHOUT DISTURBING THE CONTENTS OF THE FIELDS.

ÅDIT MODE PROVIDES THE FOLLOWING FUNCTION-KEY COMMANDS:

ÆIND (Æ1)--Á SEARCH FUNCTION. ÓELECT (VIA THE CURSOR KEYS) THE FIELD YOU WANT TO SEARCH BY, PRESS RETURN TO HIGHLIGHT THE FIELD, THEN PRESS THE RUN-STOP KEY IN 64 MODE OR THE ESCAPE KEY IN 128 MODE. ÎEXT, ENTER AS MUCH OF THE SEARCH STRING AS IS NEEDED TO MAKE IT UNIQUE, AND KEEP IN MIND THAT THE CASE OF THE LETTERS IS SIGNIFICANT; THEN PRESS RETURN. ÉF THE SEARCH FIELD IS AN INDEX KEY FIELD, THE PROGRAM GOES DIRECTLY TO THE MATCHING RECORD, IF PRESENT, OR TO THE NEXT HIGHEST RECORD. ÉF THE FIELD YOU SELECT ISN'T AN INDEX KEY FIELD, THE DISK IS SEARCHED FOR A MATCH. ×HEN ONE IS FOUND, PRESS RETURN TO FIND THE NEXT MATCHING RECORD, OR PRESS RUN-STOP (Ã-64) OR ESCAPE (Ã-128) TO ABORT THE SEARCH. ×HILE IN THIS MODE, YOU CAN PRESS Æ8 TO PRINT THE SCREEN.

×RITE (Æ2)--ÓTORES THE RECORD USING THE INDEX KEY THAT'S IN THE KEY FIELD, ALONG WITH ALL THE OTHER FIELD DATA. ÉN ×RITE MODE, YOU CAN CHANGE AN EXISTING FIELD BY TYPING OVER IT, THEN PRESSING RETURN AND Æ2. ÄEPENDING ON THE CONTENT OF THE INDEX-KEY FIELD AT THAT TIME, A NEW RECORD WILL BE CREATED OR AN EXISTING ONE OVERWRITTEN (IF IT HAS THE SAME KEY FIELD CONTENTS). ÁFTER EDITING THE LAST FIELD YOU WANT TO CHANGE, PRESS Æ2 INSTEAD OF RETURN.

ÆIRST (Æ3)--ÄISPLAYS THE FIRST RECORD IN THE DATABASE, ACCORDING TO THE INDEX KEY VALUE.

ÌAST (Æ4 )--ÄISPLAYS THE LAST RECORD IN THE DATABASE, ACCORDING TO THE INDEX KEY VALUE.

ÎEXT (Æ5)--ÄISPLAYS THE NEXT RECORD IN THE DATABASE WITH AN INDEX KEY FIELD GREATER THAN THE CURRENT ONE.

ÐREV (Æ6)--ÄISPLAYS THE PREVIOUS RECORD IN THE DATABASE WITH AN INDEX KEY FIELD LESS THAN THE CURRENT ONE.

ÎEW (Æ7)--ÂLANKS OUT ALL DATA IN THE CURRENT FORM, LEAVING AN EMPTY FORM FOR ENTERING NEW DATA.

ÐRINT (Æ8)--ÐRINTS THE FIRST 22 LINES OF THE SCREEN ON THE PRINTER.

ÔO EXIT ÅDIT MODE, PRESS RUN-STOP IN 64 MODE OR ESCAPE IN 128 MODE.

ÔO SELECT A ÕTILS COMMAND, USE THE CURSOR KEYS TO HIGHLIGHT IT AND PRESS RETURN. ÙOU CAN PRESS RUN-STOP IN 64 MODE OR ESCAPE IN 128 MODE TO RETURN TO THE MAIN MENU FROM ÕTILS.

ÄIR--ÄISPLAYS THE DISK DIRECTORY. ÉN 64 MODE, PRESSING THE SPACE BAR ONCE PAUSES THE DIRECTORY SCROLLING AND PRESSING IT A SECOND TIME REACTIVATES THE SCROLLING. ÉN 128 MODE, USE THE NO-SCROLL KEY TO PAUSE THE DISPLAY. ×HEN YOU'RE DONE WITH THE DIRECTORY, PRESS RETURN TO GO BACK TO THE FORM.

ÄOS--ÉSSUES ÄÏÓ (DISK) COMMANDS TO THE CURRENT DRIVE.

ÄRIVE#NN--ÃHANGES THE DEVICE NUMBER TO NN, WHICH IS ANY NUMBER FROM 8 TO 11. ÊUST ENTER THE NUMBER YOU WANT AT THE PROMPT AND PRESS RETURN. ÉF YOU ENTER A NUMBER THAT'S OUT OF RANGE, THE NUMBER WON'T CHANGE. ÔHE CURRENT DEVICE NUMBER IS DISPLAYED ON THE ÕTILS COMMAND LINE. ÔHE ÄRIVE COMMAND ENABLES YOU TO USE MULTIPLE DRIVES FOR YOUR FILES.

ÐRINT--ÐRODUCES HARD COPIES OF YOUR DATA IN REPORT OR LABEL FORMAT. ÒEPORT FORMAT PRINTS ALL THE DATA IN A HORIZONTAL LINE, WHILE LABEL FORMAT PRINTS ONE LINE AT A TIME. ÔHE ÐRINT COMMAND LETS YOU SELECT FIELDS IN THE ORDER YOU WANT THEM PRINTED, IF YOUR PRINTER IS DEVICE 4.

ÓEQ--ÃREATES A SEQUENTIAL FILE OF SELECTED FIELDS, IN THE ORDER YOU SELECT THEM, AND SORTS THEM IF YOU WISH. ÔHE FORMAT OF A ÓEQ FILE IS ONE FIELD OF DATA FOLLOWED BY A CARRIAGE RETURN. ÔHERE'S AN EXTRA CARRIAGE RETURN AT THE END OF EACH RECORD IN THE FILE. ÓEQ FILES CAN BE READ DIRECTLY INTO MANY WORD PROCESSORS.

ÕSR--ÃREATES A USER FILE OF SELECTED FIELDS, IN THE ORDER YOU SELECT THEM, AND SORTS THEM IF YOU WISH.

ÒEMEMBER, THE ÐRINT, ÓEQ AND ÕSR COMMANDS CAN BE EXECUTED ONLY IF A DATABASE IS CURRENTLY OPEN.

ÔO SELECT FIELDS TO BE OUTPUT BY THE ÐRINT, ÓEQ OR ÕSR COMMAND, MOVE THE CURSOR TO EACH FIELD YOU WANT AND PRESS RETURN. ×HEN YOU MOVE THE CURSOR FROM THAT FIELD, THE FIELD WILL BE HIGHLIGHTED. ÙOU CAN'T CANCEL A FIELD SELECTION, SO BE CAREFUL IN MAKING YOUR CHOICES. ÙOU CAN SELECT THE FIELDS IN ANY ORDER--THE KEY FIELD HAS NO EFFECT HERE--AND THE ORDER YOU CHOOSE WILL DETERMINE HOW THE OUTPUT RECORDS ARE BUILT.

ÉF YOU CHOOSE THE ÓORT OPTION IN THE ÐRINT, ÓEQ AND ÕSR COMMANDS, THE ORDER IN WHICH YOU SELECT FIELDS WILL DETERMINE THE SORTED ORDER OF THE RECORDS THAT ARE OUTPUT.

ÔHE ÃLOSE COMMAND IN THE MAIN MENU CLOSES A DATABASE, UPDATES THE INDEX ON THE DISK AND CLEARS THE FORM FROM THE SCREEN. ÁS A SAFEGUARD, YOU CAN'T EXIT ÒÕÎ ÆILE 1.0 WITHOUT CLOSING THE CURRENT DATABASE.

ÅØÉÔ
Ø--ÔHE EØIT COMMAND IS USED TO LEAVE ÒÕÎ ÆILE 1.0.