Discussion:
SQLDataSet GetMetadata
(too old to reply)
Craig Stuntz [TeamB]
2007-11-28 14:21:13 UTC
Permalink
I use UpdateMode = upWhereKeyOnly and I'm pretty sure the database
uses the PK index to locate records faster, even if GetMetadata is
false.
TSQLDataSet could use the metadata info to determine which
column(s) are in the PK when constructing its SQL. But you can't 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 : http://blogs.teamb.com/craigstuntz
How to ask questions the smart way:
http://www.catb.org/~esr/faqs/smart-questions.html
Erick Sasse
2007-11-28 14:27:43 UTC
Permalink
Post by Craig Stuntz [TeamB]
and you can manually
specify it with pfInKey if you have persistent TFields anyway.
That's what I do, so I don't need GetMetadata enabled? It won't help me
in anything else?
--
Erick Sasse
Craig Stuntz [TeamB]
2007-11-28 14:34:11 UTC
Permalink
Post by Erick Sasse
Post by Craig Stuntz [TeamB]
and you can manually
specify it with pfInKey if you have persistent TFields anyway.
That's what I do, so I don't need GetMetadata enabled?
I believe that's true. It may do other things, but I'm not sure what
they would be. It certainly covers the items mentioned in Help.
--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their
server: http://support.borland.com/entry.jspa?externalID=293
Loading...