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:
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. |
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.