Advanced Techniques in dBASE III PLUS

Alan Simpson

Software Diskette

Here is the disk containing systems from my book Advanced
Techniques in dBASE III PLUS. The disk is IBM double-sided,
double-density format using IBM DOS 2.1 as the operating system.

The first thing you should do with this disk is make a backup
copy of it using the DOS COPY command. On a PC, load this disk
into Drive A, and a blank formatted disk into drive B. At the A>
prompt, enter the command:

COPY *.* B:

and press RETURN.

On a hard disk system, you can simply copy all the programs to
the same directory on your hard disk that contains dBASE III.
Log onto drive C and the appropriate directory, and use the
command:

COPY A:*.*

to copy all the files. Optionally, use the COPY command with a
specific file name to copy a single file; e.g.

COPY A:StatProc.PRG

(NOTE: A handy technique to use with a hard disk containing
several directories is to enter the command:

PROMPT $P$G

at the C> prompt. This displays the name of the currently logged
directory along with the C> prompt. You can put PROMPT $P$G into
your AutoExec.BAT file if you use one).

In the interest of conserving disk space, I've only included full
systems and more advanced command files and databases from later
chapters in the book. None of the command files or databases
discussed in Chapters 1 - 3 are included on the disk.

Also, none of the databases used in the systems contain any data;
they are all empty. Therefore, if you want to try out a system,
be sure to select menu options to add data to the databases
first. Options which display reports and allow edits will not
show any data until you've entered some data into the files.

If you are using a PC or any other computer with two floppy
disks, you might want to copy individual systems to separate
diskettes. I've included a few batch files to make this task
easier for you. The names of the batch files, and the systems
they copy, are listed below:

Batch program Copies from drive A to Drive B

COPYMEM.BAT Membership system
COPYINV.BAT Inventory System
COPYAR.BAT Accounts Receivable System
COPYGEN.BAT General programs (Chapter 21)

Batch files are run directly from the DOS prompt (e.g. A>, B>, or
C>). If you are not sure how to use batch files, check you DOS
manual for details.

If you have a problem with any of the files on this disk, please
contact me directly (NOT the publisher of the book) at the
address:

Alan Simpson
SMS Software
P.O. Box 2802
La Jolla, CA 92038-2802


The following pages list the files included on this disk in
alphabetical order.

Note that any compiled files (e.g. those with the extension .EXE
or .COM) are run from the DOS A>, B>, or C> prompt, and NOT from
the dBASE dot prompt. On a computer with two floppy disks, you
may need to leave your DOS disk in Drive A, and put the No. 2
disk from this package in drive B. From the DOS A> prompt, enter
the B: specification followed by the name of the program to run
(e.g. B:TEST1 or B:PASCII) (and press Return of course).

Note that only Clipper-compiled sample programs (Test1.EXE and
Test4.EXE) are included on the disk. At the time this disk was
created, the WordTech Native Code compiler was still in the Beta-
testing stage. While the programs ran fine, and at about the
same speed, as the Clipper-compiled programs, it did not seem to
be a safe idea to distribute programs that have been compiled
with a pre-released version of the compiler.

Thanks for purchasing the book and diskette. And I hope all this
helps you to master a truly great programming language!

Files Listed Alphabetically: Diskette # 1

FileName Description Page(s)

ADDNAME2.FMT Format file with embedded graphics characters 102-103
ADDNAMES.FMT Format file for adding names to Members.DBF 35, 99
ADDNAMES.SCR Screen Painter screen for AddNames.FMT 98
ADDNEW.PRG Add new names to the Membership system 101
ADDNUMBS.PRG Add new items to the Master inventory file 186
AGESUMM.PRG Display A/R Aging and Summary reports 338
AGING.FRM A/R Aging report format 337
ALLMAST.FRM Inventory Master File report format 188-189
AR.PRG A/R system main menu 305-306
AREDIT.PRG A/R system Edit menu 316
ARHIST.PRG A/R history report menu 342-343
ARPRINT.PRG A/R reports menu 328-329
ARSTAT.PRG A/R current status report 335
ARSUMM.FRM A/R summary report format 336
ARUPDATE.PRG Updates Inventory Master file from A/R Charges 358
ASCII.PRG Command file to shows ASCII codes and characters 103
BILLHIST.DBF Billing History database 285
BILLPROC.PRG Procedure file for printing invoices 330-332
BILLS.PRG Prints A/R monthly invoices 334
BUSPROCS.PRG Business procedures (payment, future value, etc) 373
CHARGES.DBF A/R Charges database 283,357
CHECKS.DBF Write checks (uses translation procedure) 366
CHRGNO.NDX Index file for Charges.DBF 283
CODEHIST.FRM A/R History report format 341
COPYAR.BAT Copy A/R System system from drive A to B
COPYGEN.BAT Copy General files from drive A to B
COPYINV.BAT Copy Inventory system from drive A to B
COPYMEM.BAT Copy Membership system from drive A to B
CUSHIST1.FRM A/R History report format 341
CUSHIST2.FRM A/R History report format 342
CUSTNAME.NDX Index file for Customer.DBF 283
CUSTNO.NDX Index file for Customer.DBF 282
CUSTOMER.DBF Main A/R database 282
DATHIST1.FRM A/R History report format 341
DATHIST2.FRM A/R History report format 341
DEBUG.DBF Debugging Aid database 362
DEBUG.PRG Debugging Aid program 363-365
DIRECTOR.FRM Membership System Directory report format 110-115
DUPCHECK.PRG Check for duplicates in the Membership system 147-148
EDCHRG.PRG Edit Charges in the A/R system 321-322
EDCUST.PRG Edit Customer data in the A/R system 318
EDITDEL.PRG Edit/Delete records in the Membership system 140-141
EDNAMES.FMT Format file for editing membership data 134
EDNAMES.SCR Screen Painter screen for EdNames.FMT 135
EDPAY.PRG Edit payments in the A/R system 324-325
ENGLISH.PRG Create English.MEM memory file 366
FEDCHRG.FMT Format file for editing A/R Charges 320
FEDCHRG.SCR Screen Painter screen for FedChrg.FMT 319
FEDCUST.FMT Format file for editing A/R Customers 317
FEDCUST.SCR Screen Painter Screen for FedCust.FMT 317
FEDPAY.FMT Format screen for editing A/R payments 324
FEDPAY.SCR Screen Painter screen for FedPay.FMT 323
FNEWCHRG.FMT Format file for adding new A/R charges 310
FNEWCHRG.SCR Screen Painter screen for FNewChrg.FMT 310
FNEWCUST.FMT Format file for adding new A/R Customers 307
FNEWCUST.SCR Screen Painter screen for FNewCust.FMT 308
FNEWPAY.FMT Format file for adding new A/R payments 314
FNEWPAY.SCR Screen Painter screen for FNewPay.FMT 313
IMENU.PRG Inventory System main menu 173
ISCREEN1.FMT Format file for editing inventory data 181-183
ISCREEN1.SCR Screen Painter screen for Iscreen1.FMT 182
MASTER.DBF Master file for the Inventory system 166
MASTER.NDX Index file for Master.DBF 166
MEDIT.PRG Edit master inventory file 206
MEMBERS.DBF Membership system database 72
MEMBERS.PRG Main menu for membership system 82
MEMBERS.QRY Query form for membership system 121
MMENU.PRG Menu for Master Inventory file management 180
MREPORTS.PRG Menu for Master Inventory reports 195-196
NAMES.NDX Index file for Members.DBF 72
NEWCHRG.PRG Add new charges to the A/R system 312
NEWCUST.PRG Add new customers to the A/R system 308-309
NEWEDIT.PRG Edit the New Stock file in Inventory 264-276
NEWPAY.PRG Add new payments to the A/R system 315
NEWREPS.PRG Print reports from the Inventory New Stock file 249-250
NEWSTOCK.DBF New Stock transactions for Inventory system 168
NEWSTOCK.FRM Report format for Inventory New Stock report 248
NEWSTOCK.NDX Index File for NewStock.DBF 168
NEWSTOCK.PRG Data Entry program for Inventory New Stock 245-246
NMENU.PRG Menu for managing Inventory New Stock 241
ONORDER.FRM Report format for Inventory On-Order report 191
ORDERS.PRG Create Inventory purchase orders 201-203
PAYHIST.DBF History file for A/R payments 285
PAYMENTS.DBF A/R payment transactions 284
PAYNO.NDX Index file for Payments.DBF 284
POS.PRG Point-of-Sale Data Entry for Inventory 223-227
POST.PRG Post A/R balances to main database 346-349
PRINSTOP.PRG Routine to halt the printer with a keypress 156
PRINTDI2.PRG Above with "Press any key to stop printer" option 157
PRINTDIR.PRG Optional program for printing Membership Directory 153
PROCLIB1.PRG A/R system procedure file 294-295
PROCLIB2.PRG Procedure file with WordWrap procedure 371
READ.ME This document
REORDERS.FRM Inventory Reorder report format file 189-190
REPORTS.PRG Membership system reports menu 129-131
SALEDIT.PRG Edit the Inventory system sales transaction file 267-269
SALES.DBF Inventory system sales transactions 167
SALES.FRM Sales transaction report format (Inventory) 229-230
SALES.NDX Index file for Sales.DBF 167
SALREPS.PRG Inventory sales reports menu 235-236
SMENU.PRG Inventory System Sales menu 211
STATPROC.PRG Statistical Procedures (Max, Min, Var, Std) 375
SUMMARY.DBF A/R system summary database, used in updates 345
TEST.DBF Database to test the statistical procedures 376
TEST.PRG Command file to test the Debug.PRG program 360
TRANSLAT.PRG Convert numbers to English 368
TWOCOL.LBL Mailing label format file for Membership system 110
UPDATER.PRG Updates Inventory Master from Transaction files 258-259
WRAPTEST.PRG Test the Word-Wrap procedure 371
ZIPS.NDX Index file for Members.DBF 72

Diskette # 2

ASCII.ASM Unassembled ASCII code program 399
ASCII.COM Assembled ASCII program, to run from DOS prompt 399
ASCII.PAS ASCII program written in Turbo Pascal (402)
CTEST.DBF Database used by test programs 413
INKEY.PRG Program to display INKEY() codes 383
PASCII.COM Compiled ASCII program (Turbo Pascal) (402)
TEST1.EXE Clipper compiled version of Test1.PRG 414
TEST1.PRG Program to test compiler effects 412
TEST2.PRG Program to test compiler effects 412
TEST3.PRG Program to test compiler effects 413
TEST4.EXE Clipper compiled version of Test4.PRG 414
TEST4.PRG Program to test compiler effects 413
TESTMENU.PRG Sample "light bar" menu 378-383




Files Listed by Page Number: Diskette # 1

Page(s) FileName Description

COPYAR.BAT Copy A/R System system from drive A to B
COPYGEN.BAT Copy General files from drive A to B
COPYINV.BAT Copy Inventory system from drive A to B
COPYMEM.BAT Copy Membership system from drive A to B
READ.ME This document
35, 99 ADDNAMES.FMT Format file for adding names to Members.DBF
72 MEMBERS.DBF Membership system database
72 NAMES.NDX Index file for Members.DBF
72 ZIPS.NDX Index file for Members.DBF
82 MEMBERS.PRG Main menu for membership system
98 ADDNAMES.SCR Screen Painter screen for AddNames.FMT
101 ADDNEW.PRG Add new names to the Membership system
102-103 ADDNAME2.FMT Format file with embedded graphics characters
103 ASCII.PRG Command file to shows ASCII codes and characters
110-115 DIRECTOR.FRM Membership System Directory report format
110 TWOCOL.LBL Mailing label format file for Membership system
121 MEMBERS.QRY Query form for membership system
129-131 REPORTS.PRG Membership system reports menu
134 EDNAMES.FMT Format file for editing membership data
135 EDNAMES.SCR Screen Painter screen for EdNames.FMT
140-141 EDITDEL.PRG Edit/Delete records in the Membership system
147-148 DUPCHECK.PRG Check for duplicates in the Membership system
153 PRINTDIR.PRG Optional program for printing Membership Directory
156 PRINSTOP.PRG Routine to halt the printer with a keypress
157 PRINTDI2.PRG Above with "Press any key to stop printer" option
166 MASTER.DBF Master file for the Inventory system
166 MASTER.NDX Index file for Master.DBF
167 SALES.DBF Inventory system sales transactions
167 SALES.NDX Index file for Sales.DBF
168 NEWSTOCK.DBF New Stock transactions for Inventory system
168 NEWSTOCK.NDX Index File for NewStock.DBF
173 IMENU.PRG Inventory System main menu
180 MMENU.PRG Menu for Master Inventory file management
181-183 ISCREEN1.FMT Format file for editing inventory data
182 ISCREEN1.SCR Screen Painter screen for Iscreen1.FMT
186 ADDNUMBS.PRG Add new items to the Master inventory file
188-189 ALLMAST.FRM Inventory Master File report format
189-190 REORDERS.FRM Inventory Reorder report format file
191 ONORDER.FRM Report format for Inventory On-Order report
195-196 MREPORTS.PRG Menu for Master Inventory reports
201-203 ORDERS.PRG Create Inventory purchase orders
206 MEDIT.PRG Edit master inventory file
211 SMENU.PRG Inventory System Sales menu
223-227 POS.PRG Point-of-Sale Data Entry for Inventory
229-230 SALES.FRM Sales transaction report format (Inventory)
235-236 SALREPS.PRG Inventory sales reports menu
241 NMENU.PRG Menu for managing Inventory New Stock
245-246 NEWSTOCK.PRG Data Entry program for Inventory New Stock
248 NEWSTOCK.FRM Report format for Inventory New Stock report
249-250 NEWREPS.PRG Print reports from the Inventory New Stock file
258-259 UPDATER.PRG Updates Inventory Master from Transaction files
264-276 NEWEDIT.PRG Edit the New Stock file in Inventory
267-269 SALEDIT.PRG Edit the Inventory system sales transaction file
282 CUSTNO.NDX Index file for Customer.DBF
282 CUSTOMER.DBF Main A/R database
283,357 CHARGES.DBF A/R Charges database
283 CHRGNO.NDX Index file for Charges.DBF
283 CUSTNAME.NDX Index file for Customer.DBF
284 PAYMENTS.DBF A/R payment transactions
284 PAYNO.NDX Index file for Payments.DBF
285 BILLHIST.DBF Billing History database
285 PAYHIST.DBF History file for A/R payments
294-295 PROCLIB1.PRG A/R system procedure file
305-306 AR.PRG A/R system main menu
307 FNEWCUST.FMT Format file for adding new A/R Customers
308 FNEWCUST.SCR Screen Painter screen for FNewCust.FMT
308-309 NEWCUST.PRG Add new customers to the A/R system
310 FNEWCHRG.FMT Format file for adding new A/R charges
310 FNEWCHRG.SCR Screen Painter screen for FNewChrg.FMT
312 NEWCHRG.PRG Add new charges to the A/R system
313 FNEWPAY.SCR Screen Painter screen for FNewPay.FMT
314 FNEWPAY.FMT Format file for adding new A/R payments
315 NEWPAY.PRG Add new payments to the A/R system
316 AREDIT.PRG A/R system Edit menu
317 FEDCUST.FMT Format file for editing A/R Customers
317 FEDCUST.SCR Screen Painter Screen for FedCust.FMT
318 EDCUST.PRG Edit Customer data in the A/R system
319 FEDCHRG.SCR Screen Painter screen for FedChrg.FMT
320 FEDCHRG.FMT Format file for editing A/R Charges
321-322 EDCHRG.PRG Edit Charges in the A/R system
323 FEDPAY.SCR Screen Painter screen for FedPay.FMT
324-325 EDPAY.PRG Edit payments in the A/R system
324 FEDPAY.FMT Format screen for editing A/R payments
328-329 ARPRINT.PRG A/R reports menu
330-332 BILLPROC.PRG Procedure file for printing invoices
334 BILLS.PRG Prints A/R monthly invoices
335 ARSTAT.PRG A/R current status report
336 ARSUMM.FRM A/R summary report format
337 AGING.FRM A/R Aging report format
338 AGESUMM.PRG Display A/R Aging and Summary reports
341 CODEHIST.FRM A/R History report format
341 CUSHIST1.FRM A/R History report format
341 DATHIST1.FRM A/R History report format
341 DATHIST2.FRM A/R History report format
342-343 ARHIST.PRG A/R history report menu
342 CUSHIST2.FRM A/R History report format
345 SUMMARY.DBF A/R system summary database, used in updates
346-349 POST.PRG Post A/R balances to main database
358 ARUPDATE.PRG Updates Inventory Master file from A/R Charges
360 TEST.PRG Command file to test the Debug.PRG program
362 DEBUG.DBF Debugging Aid database
363-365 DEBUG.PRG Debugging Aid program
366 CHECKS.DBF Write checks (uses translation procedure)
366 ENGLISH.PRG Create English.MEM memory file
368 TRANSLAT.PRG Convert numbers to English
371 PROCLIB2.PRG Procedure file with WordWrap procedure
371 WRAPTEST.PRG Test the Word-Wrap procedure
373 BUSPROCS.PRG Business procedures (payment, future value, etc)
375 STATPROC.PRG Statistical Procedures (Max, Min, Var, Std)
376 TEST.DBF Database to test the statistical procedures

Diskette # 2

378-383 TESTMENU.PRG Sample "light bar" menu
383 INKEY.PRG Program to display INKEY() codes
399 ASCII.ASM Unassembled ASCII code program
399 ASCII.COM Assembled ASCII program, to run from DOS prompt
(402) ASCII.PAS ASCII program written in Turbo Pascal
(402) PASCII.COM Compiled ASCII program (Turbo Pascal)
412 TEST1.PRG Program to test compiler effects
412 TEST2.PRG Program to test compiler effects
413 CTEST.DBF Database used by test programs
413 TEST3.PRG Program to test compiler effects
413 TEST4.PRG Program to test compiler effects
414 TEST1.EXE Clipper compiled version of Test1.PRG
414 TEST4.EXE Clipper compiled version of Test4.PRG