Dec 062017
 
Complete source code to Advanced Techniques in dBASE III Plus, by Alan Simpson.
File ADVANCED.ZIP from The Programmer’s Corner in
Category Dbase Source Code
Complete source code to Advanced Techniques in dBASE III Plus, by Alan Simpson.
File Name File Size Zip Size Zip Type
ADDNAME2.FMT 1241 492 deflated
ADDNAMES.FMT 1201 483 deflated
ADDNAMES.SCR 1630 610 deflated
ADDNEW.PRG 249 149 deflated
ADDNUMBS.PRG 1488 610 deflated
AGESUMM.PRG 768 379 deflated
AGING.FRM 2048 566 deflated
ALLMAST.FRM 2048 237 deflated
AR.PRG 1789 780 deflated
AREDIT.PRG 896 361 deflated
ARHIST.PRG 2560 839 deflated
ARPRINT.PRG 1116 450 deflated
ARSTAT.PRG 1578 671 deflated
ARSUMM.FRM 2048 585 deflated
ARUPDATE.PRG 1152 473 deflated
ASCII.ASM 896 323 deflated
ASCII.COM 21 21 stored
ASCII.PAS 166 135 deflated
ASCII.PRG 230 137 deflated
BILLHIST.DBF 354 157 deflated
BILLPROC.PRG 4389 1476 deflated
BILLS.PRG 1696 796 deflated
BROCHURE.TXT 20224 6044 deflated
BUSPROCS.PRG 768 257 deflated
CHARGES.DBF 354 157 deflated
CHECKS.DBF 739 234 deflated
CHRGNO.NDX 1025 324 deflated
CODEHIST.FRM 1990 1254 deflated
COPYAR.BAT 1024 238 deflated
COPYGEN.BAT 256 102 deflated
COPYINV.BAT 640 174 deflated
COPYMEM.BAT 512 146 deflated
CTEST.DBF 56320 562 deflated
CUSHIST1.FRM 1990 1236 deflated
CUSHIST2.FRM 1990 1220 deflated
CUSTNAME.NDX 1025 374 deflated
CUSTNO.NDX 1025 359 deflated
CUSTOMER.DBF 578 213 deflated
DATHIST1.FRM 1990 1251 deflated
DATHIST2.FRM 1990 1235 deflated
DEBUG.DBF 66 33 deflated
DEBUG.PRG 4096 1366 deflated
DIRECTOR.FRM 1990 940 deflated
DISKINFO.DOC 238 176 deflated
DUPCHECK.PRG 1792 795 deflated
EDCHRG.PRG 1280 603 deflated
EDCUST.PRG 768 377 deflated
EDITDEL.PRG 1536 684 deflated
EDNAMES.FMT 1212 488 deflated
EDNAMES.SCR 2048 609 deflated
EDPAY.PRG 1280 586 deflated
ENGLISH.PRG 896 367 deflated
FEDCHRG.FMT 945 443 deflated
FEDCHRG.SCR 1536 510 deflated
FEDCUST.FMT 1065 346 deflated
FEDCUST.SCR 1760 531 deflated
FEDPAY.FMT 896 389 deflated
FEDPAY.SCR 1024 439 deflated
FNEWCHRG.FMT 867 404 deflated
FNEWCHRG.SCR 1145 479 deflated
FNEWCUST.FMT 1068 347 deflated
FNEWCUST.SCR 1760 513 deflated
FNEWPAY.FMT 720 354 deflated
FNEWPAY.SCR 958 417 deflated
IMENU.PRG 1249 570 deflated
INKEY.PRG 207 154 deflated
ISCREEN1.FMT 950 429 deflated
ISCREEN1.SCR 1586 571 deflated
MASTER.DBF 512 203 deflated
MASTER.NDX 1025 336 deflated
MEDIT.PRG 1282 552 deflated
MEMBERS.DBF 512 202 deflated
MEMBERS.PRG 1187 520 deflated
MEMBERS.QRY 18 18 stored
MMENU.PRG 1065 470 deflated
MREPORTS.PRG 1736 680 deflated
NAMES.NDX 1025 161 deflated
NEWCHRG.PRG 1123 532 deflated
NEWCUST.PRG 1536 680 deflated
NEWEDIT.PRG 4992 1356 deflated
NEWPAY.PRG 1152 504 deflated
NEWREPS.PRG 2436 917 deflated
NEWSTOCK.DBF 226 100 deflated
NEWSTOCK.FRM 2048 214 deflated
NEWSTOCK.NDX 1025 301 deflated
NEWSTOCK.PRG 1609 644 deflated
NMENU.PRG 949 423 deflated
ONORDER.FRM 2048 263 deflated
ORDERS.PRG 2705 1104 deflated
PASCII.COM 11511 8553 deflated
PAYHIST.DBF 226 118 deflated
PAYMENTS.DBF 226 118 deflated
PAYNO.NDX 1025 285 deflated
POS.PRG 4992 1668 deflated
POST.PRG 5120 1622 deflated
PRINSTOP.PRG 384 180 deflated
PRINTDI2.PRG 1424 665 deflated
PRINTDIR.PRG 1197 563 deflated
PROCLIB1.PRG 2560 950 deflated
PROCLIB2.PRG 768 375 deflated
READ.ME 22272 4877 deflated
REORDERS.FRM 2048 215 deflated
REPORTS.PRG 2696 1017 deflated
SALEDIT.PRG 4653 1294 deflated
SALES.DBF 348 162 deflated
SALES.FRM 2048 231 deflated
SALES.NDX 1025 250 deflated
SALREPS.PRG 3117 1097 deflated
SMENU.PRG 1024 430 deflated
STATPROC.PRG 2048 423 deflated
SUMMARY.DBF 226 118 deflated
TEST.DBF 754 237 deflated
TEST.PRG 1408 559 deflated
TEST1.EXE 126960 55707 deflated
TEST1.PRG 256 143 deflated
TEST2.PRG 256 156 deflated
TEST3.PRG 256 160 deflated
TEST4.EXE 127056 55747 deflated
TEST4.PRG 244 163 deflated
TESTMENU.PRG 1775 727 deflated
TRANSLAT.PRG 1792 741 deflated
TWOCOL.LBL 1034 82 deflated
UPDATER.PRG 2111 681 deflated
WRAPTEST.PRG 512 275 deflated
ZIPS.NDX 1025 325 deflated

Download File ADVANCED.ZIP Here

Contents of the READ.ME file


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












 December 6, 2017  Add comments

Leave a Reply