RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TInternalSQLDataSet.GetMetadata Property

Specifies whether the SQL dataset fetches metadata information along with the data.

Pascal
property GetMetadata: Boolean;
C++
__property Boolean GetMetadata;

Use GetMetadata to turn on or off the fetching of metadata on a database object. Setting GetMetadata to False will improve performance because no additional SQL will execute in order to get index information. However, setting GetMetadata to False might slow any attempts to update data using a client dataset that is linked via a dataset provider because the resolver might not generate optimized SQL to perform the update. 

GetMetadata must be True to perform any operations that require an index. These operations include setting up master/detail relationships, updating data from a client dataset when the provider's UpdateMode is not upWhereAll, and delayed fetching of BLOB data. 

Set GetMetadata to False if you are fetching a dataset for read-only purposes. 

 

TClientDataset 

TDataSetProvider 

Fetching the Data using TSQLDataSet

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!