QSqlSelectCursor3qt

Usage

Overview

The QSqlSelectCursor class provides browsing of general SQL SELECT statements.

QSqlSelectCursor is a convenience class that makes it possible to display result sets from general SQL SELECT statements in data-aware Qt widgets. QSqlSelectCursor is read-only and does not support INSERT, UPDATE or DELETE operations.

Pass the query in at construction time, or use the QSqlSelectCursor::exec() function.

Example:

    ...
    QSqlSelectCursor* cur = new QSqlSelectCursor( "SELECT id, firstname, lastname FROM author" );
    QDataTable* table = new QDataTable( this );
    table->setSqlCursor( cur, TRUE, TRUE );
    table->refresh();
    ...
    cur->exec( "SELECT * FROM books" );
    table->refresh();
    ...

See also Database Classes.

Member function documentation

QSqlSelectCursor::QSqlSelectCursor ( const QString & query = QString::null, QSqlDatabase * db = 0 )

Constructs a read only cursor on database db using the query query.

QSqlSelectCursor::QSqlSelectCursor ( const QSqlSelectCursor & other )

Constructs a copy of other

QSqlSelectCursor::~QSqlSelectCursor ()

Destroys the object and frees any allocated resources