FoxPro

DCA 
PGDCA
FOXPRO 
Locus Info Tech, 

FoxPro

Unit-I

FoxPro - The RDBMS for PC, Concept of database, FoxPro - Versions, features, requirement of Hardware and Software FoxPro - Menu System, Working with FoxPro Creating Database File Some common operations on data-CREATE, LIST, APPEND, CLOSE, QUIT, FoxPro- Data Types Viewingand Editing Data ,Data Displaying Commands - LIST, DISPLAY, LOCATE, EDIT, CHANGE,BROWSE, REPLACE, DELETE, RECALL, PACK (All Command with various Options.)

Unit-II

File utilities in FoxPro MODIFY STRUCTURE, MEMO FIELD AND FILE UTILITIES - DISPLAY IRECTORY, COPY,  DELETE, RENAIVIE. Sorting And Indexing of Database Files Sorting & indexing  Concept Sort Commands - Single & Multiple key Advantage & Disadvantages of Sort,  indexing Vs Sorting,  Single & Multiple Key, indexing Find and seek FoxPro Report -its creation, features & Utilities, Preview,  Printing Custom Report, grouping & Sub grouping. FoxPro Label -Designing & Printing

Unit-III

Memory Variables, Date & Time Function and Keyboard Macros, Memory Variables - Creation
and uses, Simple Vs Array Saving and Restoring Memory Variables, ?l??l??? Commands Time & Date Function Keys, Keyboard Macro -Creating and Using Mathematical Commands,Functions,Arithmetic Operations, Mathematical Functions,  Mathematical commands, Statistical Functions.

Unit-IV

Programming with FoxPro Concepts and FoxPro commands file  Modify Commands Conditioning, Branching and Looping with in Program files with ,Do- While Enddo, lf - Endif, Scan-Endscan, For -Endfor Docase Endcase, Text Endtext, Executing Commands from other command files Macro Substitution, Common Error   Messages,  Debugging techniques and commands.

Unit-V

Concept of Multiple Database Files - Using multiple database files, Relationing the database – SELECTIONS,UPDATE, APPEND, FROM, COPY TO, JOIN, Relation Query by Example and SQL Custom SCREENS & USER DEFINE FUNCTIONS& OTHER TOOLS ,Create Custom Screen with@,  @_GET, @ LEDIT, @_SAY_GET_READ,  Creating Box & Lines, User Define Functions, Custom Screen Designing and their Use, FoxPro for documentation