Data and Field Types

This section contains a list of data types and functions you can use to operate on data types.

In This Section

  • Visual FoxPro Data and Field Types
    Provides information about Visual FoxPro data types, including descriptions and permissible values and the range and size of those values.

  • XML Data in Visual FoxPro
    Introduces XML data in Visual FoxPro.

  • Visual FoxPro and XML Schema Data Type Mapping
    Describes XML Schema data types and shows how they map to Visual FoxPro data types and the reverse.

  • Blob Data Type
    Describes the Blob data type, which stores binary data with indeterminate length.

  • Character Data Type
    Describes the Character data type, which stores alphanumeric text. The Character (Binary) field type stores alphanumeric text that you do not want translated across code pages.

  • Currency Data Type
    Describes the Currency data type, which stores monetary values or precise financial calculations.

  • Date Data Type (Visual FoxPro)
    Describes the Date data type, which stores date values without time values.

  • DateTime Data Type
    Describes the DateTime data type, which stores both date and time values or only date values.

  • Double Field Type
    Describes the Double field type, which offers more precision than the Numeric type.

  • Float Field Type
    Describes the Float data type, which is included for compatibility and is functionally equivalent to Numeric.

  • General Field Type
    Describes the General field type, which stores OLE objects.

  • Integer Field Type
    Describes the Integer field type, which stores non-decimal numeric values and can be used when performance and table storage limitations are important.

  • Logical Data Type
    Describes the Logical data type, which provides an efficient way to store data that has only two values.

  • Memo Field Type
    Describes the Memo field type, which stores blocks of data. The Memo (Binary) version of the Memo field type stores blocks of data that you do not want translated across code pages.

  • Numeric Data Type
    Describes the Numeric data type, which stores values indicating magnitude.

  • Varbinary Data Type
    Describes the Varbinary data type, which stores binary values and literals with fixed length without additional padding and truncating spaces.

  • Varchar Field Type
    Describes the Varchar field type, which stores alphanumeric text without additional padding and truncating trailing spaces. The Varchar (Binary) field type stores alphanumeric text that you do not want translated across code pages and without additional padding and truncating trailing spaces.

  • Variant Data Type
    Describes the Variant data type, which stores any kind of data except fixed-length data.

  • General Reference
    Includes Visual FoxPro-related technical information, including file types, file structures, and other reference information about Visual FoxPro elements.

  • Language Categories
    Contains a list of language functionality and descriptions.

  • Using Visual FoxPro
    Discusses how Visual FoxPro programming features are designed to improve developer productivity, including Access and Assign methods, support for more graphic file formats, and language to simplify programming tasks.

  • Developing Visual FoxPro Applications
    Includes conceptual information about how to develop Visual FoxPro applications, instructions for creating databases and the user interface, and other tasks needed to create Visual FoxPro applications.

  • Programming in Visual FoxPro
    Describes how you can access the full power of Visual FoxPro by creating applications. Understanding object-oriented programming techniques and the event-driven model can maximize your programming productivity.