FOXPRO

Mathematical Functions

UNIT 1

 

FOXPRO - THE RDBMS FOR PC

FoxPro – Versions
FoxPro – Versions


, features,
, features,
, features,



requirement of Hardware and Software FoxPro
 requirement of Hardware and Software FoxPro 
requirement of Hardware and Software FoxPro



Menu System,
Menu System,
Menu System,


Working with FoxPro Creating Database File Some common operations on data- CREATE,
Working with FoxPro Creating Database File Some common operations on data- CREATE,



LIST, APPEND, CLOSE, QUIT
LIST, APPEND, CLOSE, QUIT




FoxPro - Data Types
FoxPro - Data Types
FoxPro - Data Types




VIEWINING AND EDITING DATA
VIEWINING AND EDITING DATA
VIEWINING AND EDITING DATA


MODIFY STRUCTURE, MEMO FIELD AND FILE UTILITIES - File utilities in FoxPro –
MODIFY STRUCTURE, MEMO FIELD AND FILE UTILITIES - File utilities in FoxPro –



DISPLAY DIRECTORY, COPY, DELETE, and RENAME
DISPLAY DIRECTORY, COPY, DELETE, and RENAME
DISPLAY DIRECTORY, COPY, DELETE, and RENAME

UNIT 2

SORTING AND INDEXING OF DATABASE FILES 

SORTING AND INDEXING OF DATABASE FILES 

SORTING AND INDEXING OF DATABASE FILES 

 Sorting & Indexing Concept

Sorting & Indexing Concept 

Sorting & Indexing Concept 

Sort Commands - Single & Multiple Key 

Sort Commands - Single & Multiple Key 

Sort Commands - Single & Multiple Key 

Advantage & Disadvantages of Sort 

Advantage & Disadvantages of Sort 

Advantage & Disadvantages of Sort 

Indexing Vs Sorting 

Indexing Vs Sorting 

Indexing Vs Sorting 

, Single & Multiple Key Indexing 

, Single & Multiple Key Indexing 

, Single & Multiple Key Indexing 

 , FIND, SEEK, 

, FIND, SEEK, 

, FIND, SEEK, 

Rushmore Technology 

Rushmore Technology 

Rushmore Technology 

PRINTING REPORTS AND LABELS FoxPro Report - its creation,  

PRINTING REPORTS AND LABELS FoxPro Report - its creation 

PRINTING REPORTS AND LABELS FoxPro Report - its creation,  

features & Utilities 

features & Utilities 

Preview, Printing 

, Preview, Printing 

Custom Report,  

Custom Report,  

Custom Report,  

grouping & Subgrouping.

grouping & Subgrouping. 

grouping & Subgrouping. 

FoxPro Label - Designing & Printing 

FoxPro Label - Designing & Printing 

FoxPro Label - Designing & Printing 

UNIT 3

Memory Variables - Creation and Uses
Memory Variables - Creation and Uses,
Memory Variables - Creation and Uses


Simple Vs Array
 Simple Vs Array
Simple Vs Array


Saving and Restoring Memory Variables
Saving and Restoring Memory Variables
Saving and Restoring Memory Variables


Time & Date Functions and Commands,
Time & Date Functions and Commands,
Time & Date Functions and Commands,


Date Arithmetic Converting Defining Function Keys
Date Arithmetic Converting Defining Function Keys
Date Arithmetic Converting Defining Function Keys


Keyboard Macros - Creating and Using
Keyboard Macros - Creating and Using
Keyboard Macros - Creating and Using

MATHEMATICAL COMMANDS AND FUNCTIONS

Arithmetic Operations 

Arithmetic Operations 

- Mathematical Functions
- Mathematical Functions

Mathematical Commands, , Statistical Functions
Mathematical Commands, , Statistical Functions
Mathematical Commands, , Statistical Functions

UNIT 4

PROGRAMMING WITH FOXPRO

Concepts of FoxPro commands file

Concepts of FoxPro commands file

Concepts of FoxPro commands file

Modify Commands

Modify Commands

Modify Commands

Conditioning

Conditioning

Conditioning

, Branching and Looping within Program files

, Branching and Looping within Program files

, Branching and Looping within Program files

Text - Endtext,

Text - Endtext,

Text - Endtext,

Executing Commands from other command files

Executing Commands from other command files

Executing Commands from other command files

, Macro Substitution

, Macro Substitution

, Macro Substitution

ERROR CONDITIONS AND PROGRAM DEBUGGING AIDS

Common Error Massages

Common Error Massages

Common Error Massages

Debugging techniques and commands

Debugging techniques and commands

Debugging techniques and commands

UNIT-V

MULTIPLE DATA FILES

Concept of Multiple Database Files

Concept of Multiple Database Files

Concept of Multiple Database Files

 Using multiple database files

Relationing the database 

Relationing the database 

Relationing the database

SET RELATION, UPDATE, APPEND FROM, COPY TO, JOIN, Relation Query by Example and SQL

SET RELATION, UPDATE, APPEND FROM, COPY TO, JOIN, Relation Query by Example and SQL

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,

Create Custom Screen with @, @_GET, @_EDIT, _SAY_GET_READ,

Create Custom Screen with @, @_GET, @_EDIT, _SAY_GET_READ,

Creating Box & Lines,

Creating Box & Lines,

Creating Box & Lines,

User Define Functions

User Define Functions

User Define Functions

, Custom Screen

Custom Screen

, Custom Screen

Designing and their Use, FoxDoc for documentation

Designing and their Use, FoxDoc for documentation

Designing and their Use, FoxDoc for documentation