MetaDataUpdate property editor

Use the MetaDataUpdate property editor to set properties associated with metadata discovery when executing a query statement or stored procedure against a server database. Metadata is information about the data: its structure, data type, and so on. Typically, this information is extracted from the server database. In some cases, you can instruct JBuilder to extract only some or none of the metadata using constants defined for this property. Reducing the amount of metadata that JBuilder needs to obtain from your server database can improve performance, however, this is only possible in cases where the structure of your data on the server does not change.

To display this property editor, choose the metaDataUpdate property from the Inspector when any StorageDataSet component (such as a QueryDataSet) is selected in the Component Tree. The values specified in this dialog are defined in the metaDataUpdate interface and are stored in the metaDataUpdate property of the StorageDataSet.

For more information on:

Update These Column Properties

Clicking any of the properties in this group places a checkmark beside that property. Metadata is obtained from the server database for all checked properties. These settings override previously specified metadata discovery properties (if any).

Property Description
Tablename Sets the tableName and schemaName properties of the StorageDataSet from the metadata when opening the DataSet. Persistent column information is also set.
RowId Specifies that a query should be analyzed for updatability. If set, the query string may be (automatically) changed to include columns that can identify a row in a table.
Precision Specifies that the precision property of the persistent column should be overridden by the value detected in the driver's metadata.
Scale Specifies that the scale property of the persistent column should be overridden by the value detected in the driver's metadata.
Searchable Specifies that the searchable property of the persistent column should be overridden by the value detected in the driver's metadata.

All

Automatically selects all MetaDataUpdate properties. This means that when the DataSet is opened, metadata obtained from the server overrides any specified settings.

None

Automatically deselects all MetaDataUpdate properties. None of the above-listed properties are overridden by metadata obtained from the database server. Therefore, you must specify values for these properties for any persistent Column components in the StorageDataSet.

Choose this option if you prefer to specify the metadata rather than have JBuilder obtain this information from the database server. For example, you might be able to provide a better RowId than what the database server indicates. Also, for some queries, the server cannot determine a unique RowId and therefore, the DataSet is treated as not updatable. If you know that a given column or set of columns makes each row of data unique, you can provide this information and possibly make the DataSet updatable.