Hi,I created a view on a versioned ArcSDE feature class and a versioned ArcSDE table. The view is a join between the two elements.The feature class is registered as versioned without the option to move edits to base.sdetable -o create_view -T VG_PSI -t psi,pdi -c pdi.id_pdi,psi.id_iti,pdi.shape -p psswd -u user -i sde:oracle11g:fero -w pdi.id_pdi=psi.id_pdi
The created view contains some fields of the table and some fields of the feature class in addition to the geometry (shape) of the feature class.When I modify the table, the changes are made in the view.But when I change the geometry of a feature in the feature class, that geometry change doesn't happen in the view.I did some investigations and I concluded that the view does read the geometry from the "final object table" and not from the delta tables (A and D)! Normally, the opposite shoould happen. And since the feature class is registered as versioned without the option to move edits to base, the "final object table" doesn't contain the newest version of the feature class.Is there a way to make the view read from the delta tables? Or do you have any suggestion to avoid this problem?Regards.