Hello,

I am thinking about using streaming for a more refined replication. (Some of the client
apps needs to be sent only a small subset of the changes) If I understand right, with the
use of TEDBDataSet.SaveToStream descendants it is possible save the resultset in one
computer and replace the resultset of the same structured table(query ...) with
LoadFromStream on a different computer. Is this really that simple or is there something more?

I suppose indexes are not saved to the stream only the records. After/while loading the
resultset from a stream will the indexes be automatically updated?




Regards, Leslie

Leslie,

<< I am thinking about using streaming for a more refined replication. (Some
of the client apps needs to be sent only a small subset of the changes) If I
understand right, with the use of TEDBDataSet.SaveToStream descendants it is
possible save the resultset in one computer and replace the resultset of the
same structured table(query ...) with LoadFromStream on a different
computer. Is this really that simple or is there something more? >>

No, that's pretty much the whole process.

<< I suppose indexes are not saved to the stream only the records. >>

Correct.  The column information and the rows are the only thing
saved/loaded.  The column information is used during the load to ensure that
the columns are compatible with the target dataset that you're loading into.
All of the columns in the stream must be available in the target dataset by
their name (and they must be the same type), but not necessarily the same
position as the source dataset.

<< After/while loading the resultset from a stream will the indexes be
automatically updated? >>

Yes.

--
Tim Young
Elevate Software
www.elevatesoft.com