Data Types in FoxPro

allows the user to choose the most suitable data for himself from different types of data. The different types of data that can be used in FoxPro are as follows:

Data Types in FoxPro

1. Character -

This data type contains all characters A,B,C,D…….Z, 0-9 (digits) and special characters like + - % etc. can store. It can store a maximum of 254 characters. It is mainly used to write names, addresses etc. Its by default width is 10. Any number can also be character data but it cannot be used in the arithmetic process.

2. Numeric -

This data can store all types of numbers. Decimal numbers can also be used in this. The number of digits containing a decimal cannot exceed 20. The total marks cannot exceed 20. This number is made up of all +/- signs and decimals.

Can be used in field arithmetic processes. Its by default width is jo.

3. Float -

This field is mainly used in scientific calculations. This field is similar to numerical data. Since Foxpro is used for general commercial purposes, this field is rarely used. Its by default width is 10.

4. Date -

This data displays the date. This field is automatically assigned 8 bytes by FoxPro. If you have done SET CENTURY ON then you can also enter the value of its 10 characters i.e. century. But it is constant in structure.

5. Logical -

This field data only as T (True) or F (False). Its width is the character. Users can also enter Y (yes) or N (No), but they are stored by FoxPro as T (True) and F (False). 

T or Y are used for true and F or N for false. This field is mainly for decision making. There are only two options: Yes/No, Pass/Fail, Absent Present

6. Memo -

This is a special fold in which picture and sound can be stored. The width of this fold is only 10 characters but the actual capacity is huge as all the data is stored in a separate file whose expansion is .FPT This is called a memo file.

7. General -

This field can be used only in the Foxpro version based on Windows. It can store spreadsheet tables and word processing documents like memo fields. The width of this fold is also 10 characters but is equal to the space available immediately in your computer.

• A table (database file) can contain up to 255 fields. 
• The maximum width a record can have is 65500 characters.
• Up to one billion records can be stored in a field.

Also Read :

• What is FoxPro in Computer?
• What is a database in computer?
• What is the reliability of distributed systems?
• What is new in Window XP?
• What are the basic Internet terminologies?
• What are services provided by Internet?
• Advantages and Disadvantages of Distributed Databases (DDB)
• What is Artificial Intelligence (AI) short answer