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.

• 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.
  • Fetch memo fields   Specifies whether to retrieve memo fields. For more information, see FetchMemo Property.
  • Allow simultaneous fetch   Specifies whether to permit simultaneous data retrieval. For more information, see AllowSimultaneousFetch 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

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