Data Types in FoxPro

 

When creating table, we have to select the data type for each filed. Here is the list of data types in FoxPro 2.6.

Data Type

Description

Character

  • To store string data type i.e., names, words.
  • Can hold up to 254 characters
  • A-Z, a-z, 0-9, underscore & special symbols
  • Default length : 10

Numeric

  • To store numerical value with decimal places
  • 0-9, .
  • Can hold up to 20 digits.
  • Decimal part can be 0 to 18 digits
  • E.g. usage : Marks, Roll Number

 

Float

  • It has signed numbers
  • Can hold up to 20 digits
  • E.g. usage : percentage, average

Date

  • Used to store date value
  • Default format dd/mm/yy

Logical

  • Used to store Boolean value : True or False
  • Y, N

Memo

  • Used to store any amount of Text
  • The data stored in in a separate file with .fpt extension.

General

  • Used to store text data, picture et.c,
  • Used in FoxPro for Windows
Tags: