Data Access Tab, CursorAdapter Builder

Sets the Select command and CursorAdapter object schema values and other data access properties.

• Select command
  Type or construct an appropriate Select command.

  When the data source type is XML, type the Select command. In this case, the Select command should be an expression that resolves to a valid and well-formed XML string.

  When the data source type is Native, ODBC, or ADO, the Build button is available. Clicking the Build button opens the Select Command Builder dialog box.

  Select Command Builder   Specifies tables and fields to include in the Select command.

  • Table   Specifies a table you want to use. The tables in the list correspond to the tables in the selected data source.

  • Add table   Available when the data source type is Native and can be used to add tables not in the current database to the table list.

  • Available fields list   Specifies fields to include in the Select command after selecting a table, or view, if appropriate. This list appears on the left side of the Select Command Builder dialog box.

  • Add single/Add all/Remove single/Remove all   Adds a single field or all fields to the selected fields list or removes a single or all fields from the selected fields list.

  • Selected fields list   Displays selected fields, which can be reorganized by clicking and dragging the mover buttons that appear along the left side of the selected fields list. This list appears on the right side of the Select Command Builder dialog box.

• Schema
  Type the schema for the CursorAdapter object, if needed. The schema is generated automatically when the Select command is constructed using the Select Command Builder.

  If you typed the Select command, you can click the Build button, and the builder attempts to construct the schema by matching the table and column names with the available tables.

  When the data source type is XML, you cannot build a Select command, and no schema is automatically generated. When you click the Build button, the Open dialog box appears, and you can specify an XML file from which to build the schema. This XML file must be a valid XML Schema Definition (XSD) schema, a valid XML with inline XSD schema, or a valid XML with reference to a valid external XSD schema.

• Use CursorSchema when filling cursor
  Specifies the default setting to use for the lUseCursorSchema parameter in the CursorFill Method. For more information, see UseCursorSchema Property.

• Data fetching
  Specifies properties relating to how to retrieve remote data when using the Open Database Connectivity (ODBC) data source type. The following settings are available:

  • Number of records to fetch at a time   Retrieve all or a number of records at a time. For more information, see FetchSize Property.

  • Maximum number of records to fetch   Retrieve all or a maximum number of records. For more information, see MaxRecords Property.

  • Use memo when character field length >=   Use memo field size when character field length exceeds the specified value. For more information, see UseMemoSize Property.

  • Fetch remote data as needed   Retrieve data only when needed. For more information, see FetchAsNeeded Property.

  • Precompile SQL on backend server   Specifies whether to prepare SQL statements for subsequent REQUERY( ) function calls. For more information, see Prepared Property and REQUERY( ) Function.

  • Map Varchar   Enables default data type mapping from ODBC and ADO data types to the Visual FoxPro Varchar data type. For more information, see MapVarchar Property.

  • Initially open with no data Specifies the default setting to use for the lNoData parameter in the CursorFill Method. For more information, see NoData Property.

  • Fetch memo fields   Specifies whether to retrieve memo fields. For more information, see FetchMemo Property.

  • Memo… Brings up the Memo Fetching dialog box.

  • Allow simultaneous fetch   Specifies whether to permit simultaneous data retrieval. For more information, see AllowSimultaneousFetch Property.

  • Map Binary   Enables default data type mapping from ODBC and ADO data types to the Visual FoxPro Varbinary and Blob data types. For more information, see MapBinary Property.

  The Memo Fetching Properties dialog box lets you specify how the DelayedMemoFetch Method fetches Memo fields. The following settings are available:

  • Memo fetch command   Specifies the commands to use for the Memo fields fetch performed by the DelayedMemoFetch method. For more information, see FetchMemoCmdList Property.

  • Memo fetch data source type   Specifies the data source type used for the DelayedMemoFetch method. For more information, see FetchMemoDataSourceType Property.

  • Connection Settings   These three option buttons let you specify the data source for the DelayedMemoFetch method. For more information, see FetchMemoDataSource Property.

• Buffer mode override
  Specifies a buffer mode.

  Optimistic row buffering   Allows edits to a single record and locks the record only when written to disk. This is the default setting.

  Optimistic table buffering   Allows edits to all records and does not lock them until written to disk.

• Break on error
  Specifies whether to permit errors to break program execution at the location where they occurred or send them to the CursorAdapter object. For more information, see BreakOnError Property.

• XML flags
  Specifies the flag settings to pass to the XMLUPDATEGRAM( ) function, which is called when the data source type is XML and updating occurs. For more information about automatic updating, see Data Access Management Using CursorAdapters and XMLUPDATEGRAM( ) Function.

See Also

Reference

Auto-Update Tab, CursorAdapter Builder
CursorAdapter Builder
Properties Tab, CursorAdapter Builder