2BCA4 -  APPLICATION PROGRAMMING IN FOXPRO

1. Working with FoxPro

• FoxPro - Versions, features, requirement of Hardware and Software
• FoxPro -  Menu System
• Creating Database File Some common operations on data-  CREATE, LIST, APPEND, CLOSE, QUIT
• FoxPro - Data Types

VIEWING AND EDITING DATA

• Data Displaying and  Monitoring Commands - DISPLAY, LIST, LOCATE, EDIT, CHANGE, BROWSE, REPLACE, DELETE, RECALL, PACK (All Commands with various Options)

MODIFY STRUCTURE, MEMO FIELD AND FILE UTILITIES -

• File utilities in FoxPro - DISPLAY DIRECTORY, COPY, DELETE, RENAME

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, SEEK, Rushmore Technology

PRINTING REPORTS AND LABELS

• FoxPro Report - its creation, features & Utilities, Preview, Printing Custom Report, grouping & Subgrouping.
• FoxPro Label -  Designing & Printing

MEMORY VARIABLES, DATE & TIME FUNCTIONS AND KEYBOARD MACROS

• Memory Variables - Creation and Uses, Simple Vs Array
• Saving and Restoring Memory Variables,
• ?/??/??? Commands
• Time & Date Functions and Commands, Date Arithmetic
• Converting Defining Function Keys
• Keyboard Macros - Creating and Using

MATHEMATICAL COMMANDS AND FUNCTIONS

• Arithmetic Operations, Mathematical Functions, Mathematical Commands, Statistical Functions.

PROGRAMMING WITH FOXPRO

• Concepts of FoxPro commands file, Modify Commands
• Conditioning , Branching and Looping within Program files with Do- While Enddo, If - Endif, Scan-Endscan, For - Endfor, Docase-Endcase, Text - Endtext, Executing Commands from other command files, Macro Substitution

ERROR CONDITIONS AND PROGRAM DEBUGGING AIDS

• Common Error Massages
• Debugging techniques and commands

MULTIPLE DATA FILES

• Concept of Multiple Database Files - Using multiple database files
• Relationing the database - SET RELATION, UPDATE, APPEND FROM, COPY TO, JOIN, Relation Query by Example and SQL

CUSTOM SCREENS & USER DEFINE FUNCTIONS & OTHER TOOLS

• Create Custom Screen with @, @_GET, @_EDIT, @_SAY_GET_READ, Creating Box & Lines, User Define Functions, Custom Screen Designing and their Use, FoxDoc for documentation

Text & Reference Books :
 

• Foxpro Made Simple by R.K.Taxali, BPB Publications
• Mastering Foxpro 2.5 BPB Publications
  Foxpro 2.6 for Dummies - Pustak Mahal