MapVarchar Property

  • Article

The MapVarchar property for the CursorAdapter enables default data type mapping from ODBC and ADO data types to the Visual FoxPro Varchar data type.

The MapVarchar property for the XMLAdapter enables default data type mapping from XML data types to the Visual FoxPro Varchar data type.

Read/write at design time and run time.

Object.MapVarchar [= lValue]

Return Value

  • lValue
    Enables default data type mapping from ODBC, ADO, and XML data types to the Visual FoxPro Varchar data type

    The following table describes the values for lValue.

    lValue Description

    True (.T.)

    For CursorAdapter objects, the following data type mapping occurs by default:

    • SQL_WVARCHAR and SQL_VARCHAR ODBC data types map to Varchar type when the precision of the corresponding column in the data source is equal to or less than 254 bytes. Otherwise, if precision is greater than 254 bytes, these types are mapped to the Memo type.

    • adVarChar and adVarWChar ADO data types map to Varchar type when possible.

    For XMLAdapter objects, Visual FoxPro maps data that was previously mapped to Character type to Varchar type instead.

    False (.F.) (Default)

    For CursorAdapter objects, prevents default mapping from remote types to the Visual FoxPro Varchar data type. For more information, see Data Type Conversion Control.

    For XMLAdapter objects, prevents default mapping from XML types to the Visual FoxPro Varchar data type. For more information, see Visual FoxPro and XML Schema Data Type Mapping.

Remarks

Applies To: CursorAdapter | XMLAdapter

See Also

Reference

Visual FoxPro Data and Field Types

Other Resources

Properties (Visual FoxPro)