Re: Update-able View linked to Access

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

Hiroshi Inoue wrote:
> Richard Broersma Jr wrote:
> > > Please change the field name of B.ctid from hasbandctid to ctid.
> > > The name should be "ctid" for the driver to detect the field is for 
> > > versioning.
> > > A.ctid isn't needed.
> >
> > It works now!  However, I have a question.  If I have a view with more 
> > than two joined tables will
> > i need to reference the ctid from each table after the first update 
> > statement?
>
> The ctid of the target table of the rule's last statement should be 
> referenced.

Please note this is not a perfect solution.

For example, the change of table A can't be detected using the "ctid".
If you update the link table with where clause including "name" field
and update the "name" and the "tiesize" field, the "tiesize" may not
be updated.....

It seems almost impossible for the driver to solve the problems perfectly.
Essentially it's a problem of the rule system.

regards,
Hiroshi Inoue