Category : Databases and related files
Archive   : SPLUS300.ZIP
Filename : CH11.DBF

 
Output of file : CH11.DBF contained in archive : SPLUS300.ZIP
X
ßaRTEXT1C ‰qOTEST1NX‰q
@6 6 Welcome to Chapter 11. In this chapter we'll examine the 0 concept of 'layering' that allows you to design the program 0 to your needs. 0 [Note that the screens in the Category Select menu were recently 0 rearranged and, therefore, look different from this tutorial. 0 The logic, though, is the same.] 0 0 @6 6 With this option, you can "layer-in" up to 99,999,999 different layers 0 or groupings of records in the Master File. Once you identify a new 0 group of records, you can separate them by assigning a unique 0 CATEGORY number to the group while you are entering their information 0 into the Master File. From that point on, anytime you wish to 0 segregate that block of records from either the Master File or 0 Activity file, just go to the Main Program Menu and enter the Select 0 Category option. 0 0 @6 6 All records have a default category of '1'. If you were to look at 0 the entry in the Master File for the 'NBF199' truck that you entered 0 earlier, you would see in the bottom left corner: 0 - Category of Maintenance: 0 - 1 0 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄ Maintenance and Service Call Activity Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 ACS 0 Main Program Menu 0 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ 03/18/87 ³ ³ Please Choose One ³ ³ 06:10:33 ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 0 0 1) Master file options 0 0 0 2) Other Options 0 0 0 3) Select Category 0 0 0 X) Exit System 0 0 Category of maintenance: ALL 0 @11 11 Here is the Main Program Menu. Observe the last line on the screen. 0 0 @31 31 2 0 23 0 11 0 =====> 0 23 0 52 0 <===== 0 @27 27 3 0 This menu shows that 'ALL' categories have been selected. 0 To change it, select 3. 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄ Maintenance and Service Call Activity Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄ 0 Select the Category for reports and to do quick searches for data. 0 - 0 - 0 You can have 99,999,999 categories. A zero is not a category. 0 Enter a zero if your want ALL categories combined for current 0 reporting and sorting purposes. 0 Category : 0 0 0 This becomes your permanent default value unless you change it later. 0 0 0 0 0 0 Enter an "H" if you want Help 0 - 0 0 0 Enter a "C" if you want to Move all items in one category to another. 0 [Will convert all records in both the Prospect and activity files] 0 [to the new category number] 0 @11 - 11 At the Select Category menu, you have 3 options: to change the category, 0 to look at the Help file, and to move all records in one category to another. 0 For now, let's change the category to '1'. 0 0 @30 30 1 0 8 0 34 0 8 0 1 0 @2 2 0 ÄÄÄÄÄÄÄÄÄÄÄÄ Maintenance and Service Call Activity Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 ACS 0 Main Program Menu 0 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ 03/18/87 ³ ³ Please Choose One ³ ³ 06:10:58 ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 0 0 1) Master file options 0 0 0 2) Other Options 0 0 0 3) Select Category 0 0 0 X) Exit System 0 0 Category of maintenance: 1 0 @11 11 Observe that the 'Category' statement on the bottom has changed 0 from 'ALL' to '1'. 0 0 @31 31 2 0 23 0 11 0 =====> 0 23 0 52 0 <===== 0 @27 27 1 0 To see if it has changed on the other menus, enter a '1'. 0 0 0 Dallas Truck Maintenance Tracking System 0 ÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜ 0 ÕÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ͸ 0 ³ Master File Menu and Other Primary Functions ³ 0 ÃÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ´ 0 ³ ³ 0 ³ A to ADD data--Master file ³ 0 ³ G to GET/EDIT data--Master file ³ 0 ³ 1 for Activity file. ³ 0 ³ 2 for Search through Service Call data ³ 0 ³ 3 for Billings reports. ³ 0 ³ 4 for Appointments ³ 0 ³ 5 for Service Call and Activity reports ³ 0 ³ 6 for automatically creating future Activities. ³ 0 ³ H for Help. ³ 0 ³ ³ 0 ³ R to RETURN to prior menu. ³ 0 ³ ³ 0 ÔÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ; 0 0 Category of maintenance (defaults to ALL): 1 0 @11 11 As you look at the Master File Menu, you can see that this 0 statement has changed on this screen also. 0 0 @31 31 2 0 22 0 7 0 =====> 0 22 0 64 0 <===== 0 @27 27 R 0 If you were to add a record into the Master File, it would 0 have a 'Category' assigned to it of whatever category you 0 had selected. 0 Rather than add any records now, let's return to the Main Program Menu 0 by entering an 'R. 0 0 0 ÄÄÄÄÄÄÄÄÄÄÄÄ Maintenance and Service Call Activity Tracking System ÄÄÄÄÄÄÄÄÄÄÄÄ 0 0 ACS 0 Main Program Menu 0 0 ÚÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿ 0 ³ 03/18/87 ³ ³ Please Choose One ³ ³ 06:11:37 ³ 0 ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ ÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ 0 0 0 1) Master file options 0 0 0 2) Other Options 0 0 0 3) Select Category 0 0 0 X) Exit System 0 0 Category of maintenance: 1 0 @27 27 X 0 Enter an 'X' to exit the program 0 0 @6 6 Whenever you select a category and then exit the system, 0 the program remembers that more recent category when 0 you start back again. 0 - 0 In addition to setting a category, you can also renumber records in 0 on category to another . 0 With option 'C', you can renumber all items in one category to 0 another. With this option, you can move all records within a category 0 to another category or combine different categories into the same 0 category. 0 0 @6 6 This concludes Chapter 11. 0 0 0 @5 5

  3 Responses to “Category : Databases and related files
Archive   : SPLUS300.ZIP
Filename : CH11.DBF

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/