Board index » delphi » SQLDataSet GetMetadata

2007-11-28 10:12:29 PM
delphi59
I don't understand this part from the help file:
"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. "
I use UpdateMode = upWhereKeyOnly and I am pretty sure the database uses
the PK index to locate records faster, even if GetMetadata is false.
--
Erick Sasse
 

Erick Sasse writes:
column(s) are in the PK when constructing its SQL. But you can not always
determine this from the DB (e.g., with a VIEW), and you can manually
specify it with pfInKey if you have persistent TFields anyway.
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
How to ask questions the smart way:
www.catb.org/~esr/faqs/smart-questions.html
 

Craig Stuntz [TeamB] writes:
in anything else?
--
Erick Sasse