The type of pre-evaluation window used has an impact on where and when changes to a table become visible in a rowset.
The following table summarises where a row on this rowset appears, when it is updated, inserted or deleted.
|
Pre-evaluation window type
|
No
|
Full
|
Partial
|
|
UpdateL()
|
as per query
|
same position in set
|
same position in set
|
|
InsertL()
|
as per query
|
appended to the set
|
as per query, only after evaluation
|
|
DeleteL()
|
deleted
|
deleted
|
deleted
|
|
The following table summarises when a change to the underlying table affecting the rowset membership becomes visible in this
rowset.
|
Pre-evaluation window type
|
No
|
Full
|
Partial
|
|
UpdateL()
|
on navigation
|
reset and evaluate
|
evaluate
|
|
InsertL()
|
on navigation
|
reset and evaluate
|
evaluate
|
|
DeleteL()
|
on navigation
|
GetL() attempted on row
|
GetL() attempted on row
|
|
![[Index]](../../../../../../a_stock/btn_index_wt.gif){kind=small}
![[Spacer]](../../../../../../a_stock/btn_spacer.gif){kind=small}
![[Previous]](../../../../../../a_stock/btn_prev_wt.gif){kind=small}
![[Next]](../../../../../../a_stock/btn_next_wt.gif){kind=small}
![[Top]](../../../../../../a_stock/arrow_up_2.gif){kind=icon}
![[Previous]](../../../../../../a_stock/btn_prev.gif){kind=small}
![[Top]](../../../../../../a_stock/btn_top.gif)
![[Next]](../../../../../../a_stock/btn_next.gif){kind=small}