Category : Dbase (Clipper, FoxBase, etc) Languages Source Code
Archive   : DB4LESS2.ZIP
Filename : DB4ADVTC.PRN
PA2A EÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ ADVANCED DATABASE DESIGN WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF
P EÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿F
P E³COURSE INFORMATION³F
P EÀÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙF
P EThe information that follows in this course is designed toF
P Etake the student through the steps necessary to become anF
P Eefficient user of dBase IV in the shortest possible time. dBaseF
P EIV is a new system for creating and maintaining databases. It hasF
P Eits roots in earlier versions of dBase and much of it will beF
P Efamiliar to those who already know one of the previous versions.F
P EThe materials presented in DESIGNING DATABASES WITH DBASE IVF
P Eare designed for managers and first-time system designers. In itF
P Eis taught the concepts of systems analysis and design and the useF
P Eof the Control Center to create complete systems withoutF
P Eprogramming. ADVANCED DATABASE DESIGN WITH DBASE IV is designedF
P Efor those who have mastered the implementation of simple systemsF
P Eand wish to build relational systems including SQL and customF
P EdBase coding. There is emphasis on the Developer's EditionF
P Efeatures and usage.F
P EThese courses are designed to be taught in both hands-on andF
P Electure formats. In the lecture format the course will be taughtF
P Ein 2 days. In the hands on format it will be taught in 5 days.F
P EThe additional time for the hands-on students will allow ampleF
P Epractice problems to master the use of dBase IV before the end ofF
P Einstruction.F
P EThe data diskette contains the files used during thisF
P Ecourse. All examples shown during the course can be recreated atF
P Ea later time using these files. LOG to Drive A: and enterF
P EINSTALL.F
P ELicenses for the use of the course materials for trainingF
P Ewithin your company or organization are available from theF
P Esponsors of this seminar. Please contact them for additionalF
P Einformation.F
P EThese course materials including Manuals, Diskettes andF
P EHandouts were written by Bruce Troutman and are owned andF
P Ecopyrighted by:F
P EInterco International, LtdF
P E1170 Weldstone CourtF
P EAtlanta, GA 30305F
P EUSAF
P E(404) 392-0184F
P ELicences are granted for the personal use of students whoF
P Eattend courses offered by an authorized training facility. NoF
P Ereproduction or other use of the materials may be made withoutF
P Ethe written consent of Interco International, Ltd. dBASE IV is aF
P Etrademark of Ashton-Tate.
PEA2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ ADVANCED DATABASE DESIGN WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF
P EÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»F
P Eº TABLE OF CONTENTS ºF
P EÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼF
P EADVANCED TECHNIQUES AND PROGRAMMINGF
P EADVANCED QUERIES AND RELATED FILESF
P EAd Hoc Inquiries - Find only what you want 3F
P EUsing Query By Example - Examples 1-7 4F
P EMultiple File Links - Examples 8-13 11F
P EUpdates - Examples 14-15 18F
P EMULTIPLE FILE REPORT CREATIONF
P ECustom Report Design 19F
P EGrouping 19F
P EWorking with Bands 19F
P ETitle 19F
P EHeader 19F
P EBody 19F
P EFooter 20F
P ESummary 20F
P EExamples 21F
P EDATA VALIDATIONF
P EDefinition 32F
P EImportant Note on Multiple Files 33F
P EExample using TIME.DBF 34F
P EPRINCIPLES OF GOOD PROGRAMMINGF
P ESpeed vs. Cost vs. Maintenance Decisions 37F
P EThe Golden Rule 38F
P EDocumentation 38F
P EDevelopment of Systems with Developer's Edition 41F
P EPROGRAMMING WINDOWS AND MENUSF
P ECUSTOMER MENU Example 42F
P ECUSTOMER MENU Code 51F
P EJOB COST Example 52F
P EAPGEN Summary 58
PEA2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ ADVANCED DATABASE DESIGN WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF
P EPROGRAMMING TOOLS, DATA TRANSFERS AND SQLF
P EPROGRAMMING UTILITIESF
P EAutomatic Compiling to Encode and Speed Programs 59F
P ERuntime for Royalty Free Distribution 61F
P EThe Editor - Enhanced Support for Programming 63F
P EThe Debugger - Professional Support 66F
P EStep IVward - Conversion Utility 67F
P EPROGRAMMING FOR NETWORKSF
P EInstallation 70F
P EProtect 71F
P ELocking TechniquesF
P EAutolock Features 73F
P EManual Locking Consideration 73F
P EScreen Refresh 73F
P ETransaction Processing 73F
P ETRANPROC.PRG Example 74F
P EDATA TRANSFER TECHNIQUESF
P EConcepts of COPY and APPEND 75F
P ETo and FromF
P ELotus 123, Word Processors,Mainframes,F
P EMinicomputers,ASCII,DIF,SYLK 76F
P EAppending from a Fixed-Length Text File 78F
P EdBASE DIRECTF
P EDirect Manipulation of Minicomputer Data 78F
P ESQL - STRUCTURED QUERY LANGUAGEF
P EDefinitions 79F
P EData Types 79F
P ESQL Commands 80F
P ESQL and dBASE IV Programming 82F
P EIMPORTANT NEW COMMANDS AND FUNCTIONSF
P ECommands 84F
P ESet Commands 86F
P EFunctions 88F
P ESystem Variables 91F
P ECONSIDERATIONS FOR THE FUTUREF
P EOperating Systems: DOS 4.0 OS/2 92F
P ELocal Area Network Technology 92F
P EServer Technology 92
PEA2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ ADVANCED DATABASE DESIGN WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼF
P ECOURSE SUMMARY 94F
P ECOURSE EXAMPLE PROBLEMS 95F
P EREFERENCEF
P EFunction Keys 97F
P EFile Extensions 98F
P EFile Structures 99F
P EEXTRA WORKSHEETSF
P EINDEX
PEA2A ÉÍËÍ» ÉÍËÍ»F
P EÌÍÎ͹ ADVANCED DATABASE DESIGN WITH dBASE IV ÌÍÎ͹F
P EÈÍÊͼ ÈÍÊͼ
@
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
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/