Microsoft Visual FoxPro is a robust programming language and integrated development environment (IDE) that has been widely utilized for database management and application development. Released by Microsoft Visual FoxPro in the mid-1980s, Visual FoxPro evolved from earlier versions of FoxPro, enhancing its capabilities and making it a powerful tool for developers.
Microsoft Visual FoxPro One of the primary strengths of Microsoft Visual FoxPro is its object-oriented programming (OOP) capabilities. This allows developers to create reusable components, significantly improving code maintenance and scalability. With features such as classes and inheritance, developers can design applications that are both efficient and easy to manage.
Microsoft Visual FoxPro integrated development environment of Microsoft Visual FoxPro provides a comprehensive set of tools for building applications. It includes a visual designer for creating user interfaces, making it accessible for developers to design attractive and functional applications without extensive coding. The IDE also offers debugging tools that help identify and resolve issues quickly, enhancing the development process.
Microsoft Visual FoxPro shines in database management. It includes powerful data handling features, such as built-in SQL support, allowing developers to execute complex queries and manage large datasets effectively. This capability makes Visual FoxPro an ideal choice for applications that require strong data integrity and performance.
Microsoft Visual FoxPro supports various data formats and can integrate with external databases using ODBC (Open Database Connectivity). This flexibility enables developers to connect to a wide range of databases, including SQL Server and Oracle, ensuring that Visual FoxPro applications can operate within diverse environments.
Microsoft Visual FoxPro Although Microsoft discontinued official support for Microsoft Visual FoxPro in 2015, a vibrant community of users continues to thrive. Numerous forums, blogs, and online resources are available, where developers share tips, tools, and best practices. This community support is crucial for those maintaining legacy applications, as it fosters collaboration and knowledge sharing among users.
The Future of Microsoft Visual FoxPro
Microsoft Visual FoxPro While newer technologies have emerged, Microsoft Visual FoxPro remains relevant for many organizations that rely on legacy systems. Businesses that have invested in Visual FoxPro applications often face the challenge of maintaining them while considering future technology transitions. Understanding Microsoft Visual FoxPro is essential for developers working with existing applications, as it provides insights into data management practices that are still applicable today.
In conclusion, Microsoft Visual FoxPro is a significant tool in the realm of database management and application development. Its rich feature set, combined with strong community support, ensures that it remains a viable option for many businesses. Whether you are an experienced developer or new to the field, familiarity with Microsoft Visual FoxPro can enhance your programming skills and prepare you for a variety of database management challenges.
Concept Of Information
Basically information is the outcome of manipulation of data or raw facts. Technically, data are raw facts and figures that are processed or manipulated into information.
Data are a collection of facts-unorganized but able to be organized into useful information. A collection of sales orders, time sheets, and class registration cards are a few examples. Data are manipulated to produce output, such as bills and paychecks when this output can be used to help people make decisions, it is called information.
Difference between Data and Information
Data are the raw material of information and just as raw materials are transformed into finished products by a manufacturing process, raw data are transformed into information by data processing. For example, the data “27” is the raw fact which may convey several meanings such as the age of a person, or the marks obtained in an examination or the bill number but when we write “The age of Mr. Alok Sen is = 27”, which conveys a particular information to us.
Features of Information
As the information is not usually available free, the cost of acquiring information must be compared with the benefits accruing from its use. Some common features of information are as follows :
- Meaningful
- Surprise element
- Conformity with previous knowledge
- Correction to previous knowledge
- Brevity
- Accuracy
- Timeliness
- Action oriented
Introduction to Visual FoxPro
Visual FoxPro is a powerful and flexible database management system (DBMS). It is a relational database manager and hence gives you the choice to use one more than one files/tables at a time. It enables you to define relationships between two or more files/tables.
Visual FoxPro experienced the following features.
- It can handle very large data tables, and also provides tools to safeguard and insect the data.
- It provides with a set of powerful tools for sorting, retrieving and presenting data.
- Multiple database can be linked together to give rise to a pyramid structure of database system.
- Queries can be made on user’s request on the basis of selected criteria’s either from single or multiple database file.
- Reports can be generated by grouping some fields with suitable headings from a single or multiple database.
- Visual FoxPro wizard makes easy to create tables, queries, report, mailing, labels and other types of information.
- It also adds advanced features such as object oriented programming and database scheme, making it a more powerful tool for a application developers.
- It has its own menu builder to design customized menu system for organizing the whole program. It also provides customized windows for the display of suitable messages and screen activities.
Starting Visual FoxPro
Step 1: Click Start → Programs → Microsoft Visual Foxpro → Microsoft Visual Foxpro 6.0. → Visual Foxpro main window screen appears on your Screen.
Visual Foxpro windows elements are as follows.
Title Bar: Located at the top of a window and it display the window name.
Application Window : It provides an interface between the user and the program.
Command Window : Command window is normally placed at the bottom right corner of the screen and is used for typing commands.
Maximize/Restore Button : Control the window size and is located in the upper-right corner of the each window.
Minimize Button : Reduce the window size and is located in the upper-right corner of the each window.
Close Button : Closes the Visual Foxpro main window and returns to window desktop icon.
Menu Bar : Located below the title bar and lists the Visual Foxpro menu options.
Standard Toolbar : Located below the menu bar and contains buttons for performing the most common actions in Visual Foxpro.
Status Bar : Located at the bottom of the application window and displays various kind of information related to the window that is currently opened.
Visual FoxPro Lesson Plan IT Semester 1
Microsoft Visual Foxpro 6.0 (Lesson – 1)
Solve Part
- Create the following Table with your first Name and insert the following data in table
Answer: Create Database Subarna
Create Subarnalesson1 → Type Record from your lesson → Ok → Yes
2. Add the following record s to the above created file.
Answer: Type Record from your lesson → Ctrl+S → Ctrl+W.
3. Display all Records.
Answer: List
4. Display all Records expected the record no.
Answer: List Off
5. Add the following record to the above table.
Answer: Append → Type Record from your lesson → Ctrl+S → Ctrl+W → List
7. Display Only Name, Dept and Basic Fields.
Answer: List Name,Desig,Basic
8. Display Only the 3rd Record.
Answer: List For Recno()=4
9. Display the 2nd Record using GOTO – Display Command.
Answer: GoTo 2
Display
10. Close the above created .DBF file and erase the database file.
Answer: Close All
Microsoft Visual Foxpro 6.0 (Lesson – 2)
Solve Part
- Create a database file with your name with the following structure.
Answer: Create database Subarna
Create subarnalesson 2 → type record from your lesson → ok → yes
2. Add the following records to the above created file.
Answer: Type record from your lesson → Ctrl+S → Ctrl+W → List
3. Modify the above structure and insert a new field TOTAL with field type numeric and field width4.
Answer: Modi structure → Type record from your lesson → ok → yes → list
4. Calculate the total with command.
Answer: Replace all total with phy + chem + math
List
Clear
5. Display only name of those students who are getting more than 60 in PHY.
Answer: List name for PHY>60
6. Display records who are getting more than 60 in MATH and more than 160 in TOTAL.
Answer: List for math >60 and total >160
7. Display records of those persons whose name is not RANITA.
Answer: List for name <> “Ranita”
Clear
8. Display records of those persons whose roll no. is 2 and 4.
Answer: List for recno ()=2 or recno ()=4
9. Edit records of above database with EDIT command to change the content of name field,Shamim to Irfan who’s roll no is 3.
Answer: Edit fields name for recno()=3 → Type text from your lesson → Ctrl+S → Ctrl+W
10. Change of MOUMITA’s math marks with 75 (using EDIT Command).
Answer: Edit fields math for name = “Moumita” → Type number → Ctrl+S → Ctrl+W.
Microsoft Visual Foxpro 6.0 (Lesson – 3)
- Create a database file with your name with the following structure.
Answer: Open database subarna
Create subarnalesson3 → Type records from your lesson → ok → yes
2. Add the following records to the above created file.
Answer: Type records from your lesson → Ctrl+S → Ctrl+W → List
3. Increase the data of BASIC field with 20% to those persons DOB is greater than 12/25/1970.
Answer: Replace all basic with basic + (basic*20/100) for DOB >CTOD (“12/25/1970”)
List
4. Display the summation of the BASIC field.
Answer: Sum (BASIC)
5. Display records of those persons whose DESIG is MGR and DEPT is TECH.
Answer: List for DESIG= “MGR” and DEPT= “TECH”
6. Display NAME field whose DEPT is ACCT and DEPT is PERS.
Answer: List name for DEPT= “ACCT” OR DEPT= “PERS”
7. Display NAME and DOB of the employees whose BASIC is more than 5500
Answer: List NAME,DOB for BASIC>=5500
8. Change the DOB format to BRITISH type and view the records.
Answer: Set Date BRITISH
List
9. Change the DOB format to ITALIAN type and view the records.
Answer: Set Date ITALIAN
List
10. Change the DOB format to AMERICAN type and view the records.
Answer: Set Date AMERICAN
List
11. Delete 2nd and 5th record.
Answer: Delete For Recno()=2 or Recno()=5
List
12. Display Only the Deleted Records.
Answer: List For Deleted()
13. Recall all the deleted records and display records.
Answer: Recall all
List
14. Delete the 3rd record permanently and display records.
Answer: Delete for Recno()=3
Pack
List
15. Write the Steps how to Create a Query Wizard?
Answer: File → New → Query → Wizard → Query Wizard → Ok → Select Your Table → >> → Next → Field: Select Your Name Basic → Operator: Greater Then Equal → Value: >=7000 → Next → Next → Preview → Close → Finish → Save .
16. Close the above Database File.
Answer: Close all
