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]](../../../../../../stock/btn_index.gif){kind=small}
![[Glossary]](../../../../../../stock/btn_glossary.gif){kind=small}
![[Previous]](../../../../../../stock/btn_prev.gif){kind=small}
![[Next]](../../../../../../stock/btn_next.gif){kind=small}
![[Top]](../../../../../../stock/arrow_up_2.gif){kind=icon}
![[Top]](../../../../../../stock/arrow_up.gif){kind=icon}