|
||
The type of pre-evaluation window used has an impact on where and when changes to a table become visible in a rowset.
Pre-evaluation window type |
No |
Full |
Partial |
Memory usage |
none |
variable |
fixed |
Speed of navigation |
variable |
fast |
fast |
Programming |
easy |
easy |
harder |
Evaluation required |
never |
once after reset |
on-going |
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 |
|
as per query |
same position in set |
same position in set |
|
as per query |
appended to the set |
as per query, only after evaluation |
|
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 |
|
on navigation |
reset and evaluate |
evaluate |
|
on navigation |
reset and evaluate |
evaluate |
|
on navigation |
|
|