Using indices and cursors
[Contents] [Next Page] [Prev Page] [Up] [Index] [How to Search]

7 - Using indices and cursors

So far, the rows of an ADAMO table have been accessed according to the values of their ID column. The definition of indices provides the possibility of accessing a table according to values of other columns. Cursors on an index offer an alternative and more efficient way to create and operate on subsets of an entity set.

7.1 - Ordered access to the rows of a table

7.2 - Cursors

7.3 - Using indices and cursors

7.4 - Basic operations with indices

7.5 - Looping over an ordered table

7.6 - Row deleting within loops

7.7 - Selecting rows

7.8 - An example of selection

7.9 - Creating and using multiple indices

7.10 - Navigating with cursors

7.11 - A navigation example

7.12 - Another navigation example

7.13 - Combined use of indices and selectors

7.14 - Summary

___________________________________________________________________________
BR and MR - CERN PTG - ADAMO Users Guide for Version 3.3 - 11 Oct 93