Unique Table, Unique Schema, Unique Catalog Properties—Dynamic (ADO)

Enables you to closely control modifications to a particular base table in a Recordset that was formed by a JOIN operation on multiple base tables.

• Unique Table specifies the name of the base table upon which updates, insertions, and deletions are allowed.
• Unique Schema specifies the schema, or name of the owner of the table.
• Unique Catalog specifies the catalog, or name of the database containing the table.

Settings and Return Values

Sets or returns a String value that is the name of a table, schema, or catalog.

Remarks

The desired base table is uniquely identified by its catalog, schema, and table names. When the Unique Table property is set, the values of the Unique Schema or Unique Catalog properties are used to find the base table. It is intended, but not required, that either or both the Unique Schema and Unique Catalog properties be set before the Unique Table property is set.

The primary key of the Unique Table is treated as the primary key of the entire Recordset. This is the key that is used for any method requiring a primary key.

While Unique Table is set, the Delete method affects only the named table. The AddNew, Resync, Update, and UpdateBatch methods affect any appropriate underlying base tables of the Recordset.

Unique Table must be specified before doing any custom resynchronizations. If Unique Table has not been specified, the Resync Command property will have no effect.

A run-time error results if a unique base table cannot be found.

These dynamic properties are all appended to the Recordset object Properties collection when the CursorLocation property is set to adUseClient.

See Also

Applies To: Recordset Object