Re: updateable snapshot

Richard,

As I understood it from MC's SQL script, he did an insert to the SNAPSHOT table, and expected the MASTER table to change in turn.

So this is some sort of "reverse-engineering" of data he tried. How can this be possible?

Georg

"Richard Foote" <richard.foote_at_bigpond.com> schrieb im Newsbeitrag news:Ryxoa.18616$1s1.286510_at_newsfeeds.bigpond.com...
>
> "Georg Scholz" <georg.scholz_at_vienna.at> wrote in message
> news:heroa.140168$UR.1247654_at_news.chello.at...
> >
> > This is NOT possible.
> >
> > Basically, a snapshot is the same as a view.
> > The difference is that the snapshot is stored in a table, so when
> accessing
> > the snapshot, the data is promptly available and needs not to be
> calculated.
> >
> > Think of the snapshot table as a "cache" which stores view data.
> >
> > When the master table is changed, the snapshot table will be refreshed
> > (depending on your settings when creating the snapshot); but the other
way
> > round is impossible.
> >
> Hi Georg
>
> This most certainly is possible.
>
> To MC, look at the Replication API Reference manual where it has a nice
> example of how to set this all up (note you need to use Advanced
> Replication)
>
> Cheers
>
> Richard
>
>
Received on Sun Apr 20 2003 - 10:36:54 CDT