Skip to main content
Home
Live to Learn!

Main navigation

  • Home
  • Learn
    • FoxPro
    • MS-DOS
    • C PRG
    • Java
    • ASP
    • Ruby on Rails
    • ASP.NET
    • E-Books
    • Exam Preparation
    • Tools
  • Blog
  • Forums
  • Contact
User account menu
  • Log in

Breadcrumb

  1. Home
  2. FoxPro Programming

Data Types in FoxPro

Book navigation

  • FoxPro Commands - Part 1
  • Foxpro commands - Part 2
  • Data Types in FoxPro
  • Numeric Functions in FoxPro
  • Creating a Program
  • Input and Output Statements in Foxpro
  • Control Structures in Foxpro
  • Creating menu in Foxpro for DOS
  • Simple Journal Entry program
  • Simple Ledger creation & Posting Program
  • Trial Balance Program
  • Balance Sheet Program
  • Simple Weekly Calendar Generation
  • How to install FoxPro 2.6 in Windows 10 / Windows 8 / Windows 7?
  • How to install FoxPro 2.6 on Linux OS (Ubuntu 20.04 | 20.10 | 21.04)?
  • How to install FoxPro in Windows 10 64 bit using VDosPlus?
By Karthikeyan , 30 April, 2014

 

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
  • Add new comment
Tags
Foxpro

Comments

Featured Blog Posts

Convert Currency in Number to Words (Indian Rupees) - MS Excel
Foxpro Tutorial and Programs
Convert Currency in Number to Words in MS Word
Convert Currency in Number to Words (Indian Rupees) - Version 2
Best way to Use Rupee Symbol in Windows – Easy steps
Convert Currency in Number to Words - MS Access
Creating All in One Windows XP DVD with all Important Applications
RSS feed

© 2009-2025 Live to Learn.In

Terms of Use | Privacy Policy