TBufDataset procedure LoadFromStream, Loses Primary Key
lazarus / 16-Databases

----------------------------------------------------------------------
adilsonpazzini · 2019-10-28 19:25

Good afternoon,
I have problems with the procedure "BufDataset1.LoadFromStream
(DatasStream, dfBinary);"
When loading data from a TSQLQuery from a table, it loses Primary Key
information

Here's an example, for Firebird 3 with Lazarus 2.0.4 Fpc - 3.0.4 .. it
was also tested with MySQL and Postgres.


Thank you very much in advance
Adilson Pazzini

----------------------------------------------------------------------
Thaddy · 2019-10-28 19:52

TBufDataset is not supposed to keep index data.

----------------------------------------------------------------------
adilsonpazzini · 2019-10-28 20:36

Curiosity, but why not?

----------------------------------------------------------------------
marcov · 2019-10-28 22:07

I'm not too deep in this matter, but you don't really load the dataset
from the query, but store it as binary inbetween.

That (the streaming) might be step that loses the sql metadata.

----------------------------------------------------------------------
adilsonpazzini · 2019-10-29 11:36

In the tests this is what I understood, the transfer is losing this
information .. and only the Primary Key information

Strange, because if BufDataset should not have this option, then why
have the option to inform InKey

I appreciate the return

Adilson Pazzini