Data Types in FoxPro

Submitted by Karthikeyan on Wed, 30/04/2014 - 06:35

 

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