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

Other Resources