diff -r 48780e181b38 -r 578be2adaf3e Symbian3/PDK/Source/GUID-12CB6E0E-69CD-51A6-8966-3621CB26E1CD.dita --- a/Symbian3/PDK/Source/GUID-12CB6E0E-69CD-51A6-8966-3621CB26E1CD.dita Tue Jul 20 12:00:49 2010 +0100 +++ b/Symbian3/PDK/Source/GUID-12CB6E0E-69CD-51A6-8966-3621CB26E1CD.dita Fri Aug 13 16:47:46 2010 +0100 @@ -1,38 +1,38 @@ - - - - - -DBMS -rowsets overviewDBMS rowsets allow data contained in a database to be retrieved, -searched, and modified. -
Description

The API has three key concepts: rowset -base, table rowset, and SQL view.

Rowset -base

Rowsets provide the following:

    -

  • retrieving data from -a database

    • -

  • navigating the rowset -with a cursor

    • -

  • row finding and matching

    • -

  • updating or inserting -rows

    • -

  • getting the schema of -the rows within the rowset

    • -

  • extracting and setting -columns in a row

    • -

A base class is defined for all rowset types by RDbRowSet. -Concrete types of rowset derive from this.

Table rowset

This provides all the rows and columns of a table -as a rowset. Indexes can be used to order the rowset, and to provide fast -key-based row retrieval from the table. It is encapsulated in RDbTable.

SQL view

This provides a rowset based on an SQL query. It -is provided by RDbView. An SQL query is encapsulated in TDbQuery.

For -large rowsets, it can be useful to define the balance between memory usage -(greatest if the view stores the complete rowset) and speed (slowest if the -rowset is evaluated for each cursor navigation). This is called the pre-evaluation -window, and is provided by TDbWindow.

+ + + + + +DBMS +rowsets overviewDBMS rowsets allow data contained in a database to be retrieved, +searched, and modified. +
Description

The API has three key concepts: rowset +base, table rowset, and SQL view.

Rowset +base

Rowsets provide the following:

    +

  • retrieving data from +a database

    • +

  • navigating the rowset +with a cursor

    • +

  • row finding and matching

    • +

  • updating or inserting +rows

    • +

  • getting the schema of +the rows within the rowset

    • +

  • extracting and setting +columns in a row

    • +

A base class is defined for all rowset types by RDbRowSet. +Concrete types of rowset derive from this.

Table rowset

This provides all the rows and columns of a table +as a rowset. Indexes can be used to order the rowset, and to provide fast +key-based row retrieval from the table. It is encapsulated in RDbTable.

SQL view

This provides a rowset based on an SQL query. It +is provided by RDbView. An SQL query is encapsulated in TDbQuery.

For +large rowsets, it can be useful to define the balance between memory usage +(greatest if the view stores the complete rowset) and speed (slowest if the +rowset is evaluated for each cursor navigation). This is called the pre-evaluation +window, and is provided by TDbWindow.

 \ No newline at end of file