JavaScript Editor js editor     Web development 



Main Page

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



JavaScript Editor js editor     Web development