DBINFO.TXT 27/12/84 So far the only Dbase II programs I have seen in the library are a couple of SIG/M volumes, which seems a bit suprising considering the popularity of this program. So to put this lack to rights in the UK library I have submitted the following items:- (I have a lot of other Dbase II material which when time permits will also be submitted.) LABEL.CMD - a program to print three across the web labels. This program was quick lash up for my own use for printing labels where many of the same kind of label are required eg disks labels, price labels etc. A data base of label types can be maintained, when printing the number of each type to be printed can be set. This program was originally designed to run with a EPSON printer so if you are using something else you may need to change the codes in the printer file LABPRNT.CMD. NAMES.CMD & LETTERS.CMD - this is is a name and address filing system with the additional facility of producing form letters. A separate file of standard letters is maintained in the LETTER.DBF file. There are two demo letters in this file which contain more info on the program. You can print these out from the Mailmerge option from the main menu of the NAMES program. Some more details about these programs will be found at the start of the command files. *Note at the begining of the letter program there is a line which defines *the drive on which the data files are to be found, if you don't have a drive * d: you will need to edit this. All these programs are menu driven and,I hope self explanatory, to run them you will need Dbase II ver. 2.3b or later. Although basically functional, due to lack of time these programs could do with some tidying but I hope they will be of some interest to Dbase fans. Rod Smith 138 Holtye Rd East Grinstead Sussex RH19 3EA (0342) 313883 THE FILES SUBMITTED ARE:- 1NAME.DBF database file for names program. 1NAME.FMT screen format file for names program LABS.FMT screen format file for label program LABELS.CMD label startup program LABFIND.CMD part of label program LETTER.DBF data base file for letters LABPRNT.CMD part of label program LABELS.DBF label data base file LETTER.FMT screen format file for letter program DBINFO.TXT Info about db programs LETTER.NDX index file for letters LETTERS.CMD letter program NAMES.CMD name program CHECKOUT.CMD part of label program LABCLN.CMD "" LABCRE.CMD "" LABENT.CMD "" LABSEL.CMD "" MENU.CMD "" TEMPLATE.DBF Demo data base FILES.INF THIS FILE This is the db file used for storing letter lines. . use letter . disp stru STRUCTURE FOR FILE: D:LETTER .DBF NUMBER OF RECORDS: 00063 DATE OF LAST UPDATE: 00/00/00 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 LCD C 005 002 LINE C 065 ** TOTAL ** 00071 This is the dbfile used for the names part of the letter program. . use 1name . disp stru STRUCTURE FOR FILE: D:1NAME .DBF NUMBER OF RECORDS: 00002 DATE OF LAST UPDATE: 00/00/00 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 CC C 010 002 NAM1 C 012 003 NAM2 C 023 004 TITL C 035 005 COMP C 035 006 ADD1 C 035 007 ADD2 C 035 008 TOWN C 025 009 PCOD C 010 010 CONT C 035 ** TOTAL ** 00256 The following example shows how a data base file can be used as a template for the creation of another database file. The procedure is :- create template file as shown below then append records each record to represent the field of the final dbfile to be created. The db file is then created by the command "CREATE In the example the LABELS.DBF was created from the template file. . disp stru STRUCTURE FOR FILE: D:TEMPLATE.DBF NUMBER OF RECORDS: 00028 DATE OF LAST UPDATE: 00/00/00 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 FIELDNAME C 010 002 FIELDTYPE C 001 003 FIELDLEN N 003 004 FIELDDEC N 003 ** TOTAL ** 00018 The following is the template from which the labels db file was created. . list 00001 OPCD1 N 2 0 00002 GAP1 N 2 0 00003 LIN1 C 36 0 00004 OPCD2 N 2 0 00005 GAP2 N 2 0 00006 LIN2 C 36 0 00007 OPCD3 N 2 0 00008 GAP3 N 2 0 00009 LIN3 C 36 0 00010 OPCD4 N 2 0 00011 GAP4 N 2 0 00012 LIN4 C 36 0 00013 OPCD5 N 2 0 00014 GAP5 N 2 0 00015 LIN5 C 36 0 00016 OPCD6 N 2 0 00017 GAP6 N 2 0 00018 LIN6 C 36 0 00019 OPCD7 N 2 0 00020 GAP7 N 2 0 00021 LIN7 C 36 0 00022 OPCD8 N 2 0 00023 GAP8 N 2 0 00024 LIN8 C 36 0 00025 SELCOD1 C 6 0 00026 SELCOD2 C 6 0 00027 PRNNO N 4 0 00028 INC L 1 0 This is the db file produced. . use labels . disp stru STRUCTURE FOR FILE: D:LABELS .DBF NUMBER OF RECORDS: 00000 DATE OF LAST UPDATE: 00/00/00 PRIMARY USE DATABASE FLD NAME TYPE WIDTH DEC 001 OPCD1 N 002 002 GAP1 N 002 003 LIN1 C 036 004 OPCD2 N 002 005 GAP2 N 002 006 LIN2 C 036 007 OPCD3 N 002 008 GAP3 N 002 009 LIN3 C 036 010 OPCD4 N 002 011 GAP4 N 002 012 LIN4 C 036 013 OPCD5 N 002 014 GAP5 N 002 015 LIN5 C 036 016 OPCD6 N 002 017 GAP6 N 002 018 LIN6 C 036 019 OPCD7 N 002 020 GAP7 N 002 021 LIN7 C 036 022 OPCD8 N 002 023 GAP8 N 002 024 LIN8 C 036 025 SELCOD1 C 006 026 SELCOD2 C 006 027 PRNNO N 004 028 INC L 001 ** TOTAL ** 00338 . quit *** END RUN dBASE II ***