Share via


Table Field Naming Conventions

Follow this suggested format for naming fields in tables. These conventions are recommended, not required.

Alias.TypeName

Parameters

  • Type
    Notes the data type for a field in a table. Suggested prefixes for Type are as follows.
    Type Description Example
    c Character
    Customer.cLastName
    d Date
    Customer.dBirthDay
    t Datetime
    Customer.tLastMod
    b Double
    Customer.bRate
    f Float
    Customer.fValue
    g General
    Customer.gPicture
    l Logical
    Customer.lSellMail
    m Memo
    Customer.mComments
    y Currency
    Customer.yYearTDate
    n Numeric
    Customer.nItems
    I Integer
    Customer.iCustID

Remarks

Prefixes aren't required, but are recommended as good programming practice. Using a prefix does not dictate the contents of a field — in Visual FoxPro, prefixes are used only as a naming convention. For example, adding the prefix "d" does not check that the contents of a field is a date, but it does help you remember the data type contained in the field.

For more information, see Visual FoxPro Naming Rules.

See Also

Constant Naming Conventions | Object Naming Conventions | Variable Naming Conventions | Visual FoxPro Naming Rules | Window Naming Conventions