Редактирование: Qt:Документация 4.3.2/qsqltablemodel

{{Qt4.3.2_header}}

=Описание класса QSqlTableModel<br /><sup><sup>[модуль [[Qt:Документация 4.3.2/qtsql | QtSql]] ] </sup></sup>=

Класс QSqlTableModel предоставляет редактируемую модель данных для одной таблицы базы данных. [[#details | Подробнее...]]
<source lang="cpp-qt"> #include <QSqlTableModel></source> 
Наследует [[Qt:Документация 4.3.2/qsqlquerymodel | QSqlQueryModel]].

Наследуется [[Qt:Документация 4.3.2/qsqlrelationaltablemodel | QSqlRelationalTableModel]].

*[[Qt:Документация 4.3.2/qsqltablemodel-members | Список всех членов включая унаследованные]]
<div id="public-types"></div>
===Открытые типы===

*enum '''[[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | EditStrategy]]''' { OnFieldChange, OnRowChange, OnManualSubmit }
<div id="public-functions"></div>
===Открытые функции===

*'''[[Qt:Документация 4.3.2/qsqltablemodel#QSqlTableModel | QSqlTableModel]]''' ( QObject * ''parent'' = 0, QSqlDatabase ''db'' = QSqlDatabase() )
*virtual '''[[Qt:Документация 4.3.2/qsqltablemodel#dtor.QSqlTableModel | ~QSqlTableModel]]''' ()
*QSqlDatabase '''[[Qt:Документация 4.3.2/qsqltablemodel#database | database]]''' () const
*EditStrategy '''[[Qt:Документация 4.3.2/qsqltablemodel#editStrategy | editStrategy]]''' () const
*int '''[[Qt:Документация 4.3.2/qsqltablemodel#fieldIndex | fieldIndex]]''' ( const QString &amp; ''fieldName'' ) const
*QString '''[[Qt:Документация 4.3.2/qsqltablemodel#filter | filter]]''' () const
*bool '''[[Qt:Документация 4.3.2/qsqltablemodel#insertRecord | insertRecord]]''' ( int ''row'', const QSqlRecord &amp; ''record'' )
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#insertRows | insertRows]]''' ( int ''row'', int ''count'', const QModelIndex &amp; ''parent'' = QModelIndex() )
*bool '''[[Qt:Документация 4.3.2/qsqltablemodel#isDirty | isDirty]]''' ( const QModelIndex &amp; ''index'' ) const
*QSqlIndex '''[[Qt:Документация 4.3.2/qsqltablemodel#primaryKey | primaryKey]]''' () const
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#removeColumns | removeColumns]]''' ( int ''column'', int ''count'', const QModelIndex &amp; ''parent'' = QModelIndex() )
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#removeRows | removeRows]]''' ( int ''row'', int ''count'', const QModelIndex &amp; ''parent'' = QModelIndex() )
*virtual void '''[[Qt:Документация 4.3.2/qsqltablemodel#revertRow | revertRow]]''' ( int ''row'' )
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#select | select]]''' ()
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#setData | setData]]''' ( const QModelIndex &amp; ''index'', const QVariant &amp; ''value'', int ''role'' = Qt::EditRole )
*virtual void '''[[Qt:Документация 4.3.2/qsqltablemodel#setEditStrategy | setEditStrategy]]''' ( EditStrategy ''strategy'' )
*virtual void '''[[Qt:Документация 4.3.2/qsqltablemodel#setFilter | setFilter]]''' ( const QString &amp; ''filter'' )
*bool '''[[Qt:Документация 4.3.2/qsqltablemodel#setRecord | setRecord]]''' ( int ''row'', const QSqlRecord &amp; ''record'' )
*virtual void '''[[Qt:Документация 4.3.2/qsqltablemodel#setSort | setSort]]''' ( int ''column'', Qt::SortOrder ''order'' )
*virtual void '''[[Qt:Документация 4.3.2/qsqltablemodel#setTable | setTable]]''' ( const QString &amp; ''tableName'' )
*virtual void '''[[Qt:Документация 4.3.2/qsqltablemodel#sort | sort]]''' ( int ''column'', Qt::SortOrder ''order'' )
*QString '''[[Qt:Документация 4.3.2/qsqltablemodel#tableName | tableName]]''' () const

*15 открытых функций унаследованных от [[Qt:Документация 4.3.2/qsqlquerymodel#public-functions | QSqlQueryModel]]
*1 открытая функция унаследованная от [[Qt:Документация 4.3.2/qabstracttablemodel#public-functions | QAbstractTableModel]]
*34 открытых функций унаследованных от [[Qt:Документация 4.3.2/qabstractitemmodel#public-functions | QAbstractItemModel]]
*29 открытых функций унаследованных от [[Qt:Документация 4.3.2/qobject#public-functions | QObject]]
<div id="public-slots"></div>
===Открытые слоты===

*virtual void '''[[Qt:Документация 4.3.2/qsqltablemodel#revert | revert]]''' ()
*void '''[[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]]''' ()
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#submit | submit]]''' ()
*bool '''[[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]]''' ()

*2 открытых слотов унаследованных от [[Qt:Документация 4.3.2/qabstractitemmodel#public-slots | QAbstractItemModel]]
*1 открытый слот унаследованный от [[Qt:Документация 4.3.2/qobject#public-slots | QObject]]
<div id="signals"></div>
===Сигналы===

*void '''[[Qt:Документация 4.3.2/qsqltablemodel#beforeDelete | beforeDelete]]''' ( int ''row'' )
*void '''[[Qt:Документация 4.3.2/qsqltablemodel#beforeInsert | beforeInsert]]''' ( QSqlRecord &amp; ''record'' )
*void '''[[Qt:Документация 4.3.2/qsqltablemodel#beforeUpdate | beforeUpdate]]''' ( int ''row'', QSqlRecord &amp; ''record'' )
*void '''[[Qt:Документация 4.3.2/qsqltablemodel#primeInsert | primeInsert]]''' ( int ''row'', QSqlRecord &amp; ''record'' )

*14 сигнала унаследованных от [[Qt:Документация 4.3.2/qabstractitemmodel#signals | QAbstractItemModel]]
*1 сигнал унаследованный от [[Qt:Документация 4.3.2/qobject#signals | QObject]]
<div id="protected-functions"></div>
===Защищенные функции===

*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#deleteRowFromTable | deleteRowFromTable]]''' ( int ''row'' )
*QModelIndex '''[[Qt:Документация 4.3.2/qsqltablemodel#indexInQuery | indexInQuery]]''' ( const QModelIndex &amp; ''item'' ) const
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#insertRowIntoTable | insertRowIntoTable]]''' ( const QSqlRecord &amp; ''values'' )
*virtual QString '''[[Qt:Документация 4.3.2/qsqltablemodel#orderByClause | orderByClause]]''' () const
*virtual QString '''[[Qt:Документация 4.3.2/qsqltablemodel#selectStatement | selectStatement]]''' () const
*void '''[[Qt:Документация 4.3.2/qsqltablemodel#setPrimaryKey | setPrimaryKey]]''' ( const QSqlIndex &amp; ''key'' )
*void '''[[Qt:Документация 4.3.2/qsqltablemodel#setQuery | setQuery]]''' ( const QSqlQuery &amp; ''query'' )
*virtual bool '''[[Qt:Документация 4.3.2/qsqltablemodel#updateRowInTable | updateRowInTable]]''' ( int ''row'', const QSqlRecord &amp; ''values'' )

*3 защищенных функций унаследованных от [[Qt:Документация 4.3.2/qsqlquerymodel#protected-functions | QSqlQueryModel]]
*14 защищенных функций унаследованных от [[Qt:Документация 4.3.2/qabstractitemmodel#protected-functions | QAbstractItemModel]]
*7 защищенных функций унаследованных от [[Qt:Документация 4.3.2/qobject#protected-functions | QObject]]

===Дополнительные унаследованные члены===

*1 свойство унаследованное от [[Qt:Документация 4.3.2/qobject#properties | QObject]]
*5 статических открытых члена унаследованных от [[Qt:Документация 4.3.2/qobject#static-public-members | QObject]]
<div id="details"></div><hr />
==Подробное описание==

Класс QSqlTableModel предоставляет редактируемую модель данных для одной таблицы базы данных.

QSqlTableModel это высокоуровневый интерфейс к записям одной таблицы базы данных с возможностью и чтения и записи. Он является надстройкой нижнего уровня [[Qt:Документация 4.3.2/qsqlquery | QSqlQuery]] и может быть использован, чтобы предоставлять данные для классов представлений таких как [[Qt:Документация 4.3.2/qtableview | QTableView]]. Например:
<source lang="cpp-qt">     QSqlTableModel *model = new QSqlTableModel;
     model->setTable("employee");
     model->setEditStrategy(QSqlTableModel::OnManualSubmit);
     model->select();
     model->removeColumn(0); // прячим поле ID
     model->setHeaderData(0, Qt::Horizontal, tr("Name"));
     model->setHeaderData(1, Qt::Horizontal, tr("Salary"));

     QTableView *view = new QTableView;
     view->setModel(model);
     view->show();</source> 
Мы устанавливаем имя SQL таблицы и стратегию редактирования, затем мы устанавливаем метки отображаемые в заголовках представления. Стратегия редактирования предписывает, когда изменения сделаные пользователем в представлении применяются в базе данных. Возможные значения стратегии, это [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnFieldChange]], [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnRowChange]], и [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnManualSubmit]].

QSqlTableModel может быть также использован для доступа к базе данных программно, без связывания ее с представлением:
<source lang="cpp-qt">     QSqlTableModel model;
     model.setTable("employee");
     QString name = model.record(4).value("name").toString();</source> 
Фрагмент кода выше извлекает поле <tt>salary</tt> из 4 записи выбранной по запросу <tt>SELECT * FROM employee</tt>.

Имеется возможность установить фильтры используя [[Qt:Документация 4.3.2/qsqltablemodel#setFilter | setFilter]](), или изменить порядок сортировки используя [[Qt:Документация 4.3.2/qsqltablemodel#setSort | setSort]](). В конце, вы должны вызвать [[Qt:Документация 4.3.2/qsqltablemodel#select | select]](), чтобы заполнить модель данными.

Пример [[Qt:Документация 4.3.2/sql-tablemodel | sql/tablemodel]] илюстрирует, как использовать QSqlTableModel в качестве источника данных для [[Qt:Документация 4.3.2/qtableview | QTableView]].

QSqlTableModel не предоставляет непосредственную поддержку внешних ключей. Если вы хотите разрешить внешние ключи используйте [[Qt:Документация 4.3.2/qsqlrelationaltablemodel | QSqlRelationalTableModel]] и [[Qt:Документация 4.3.2/qsqlrelationaldelegate | QSqlRelationalDelegate]].

The [[Qt:Документация 4.3.2/sql-driver#qsqlite | QSQLITE]] driver locks for updates until a select is finished. QSqlTableModel fetches data (QSqlQuery::fetchMore()) as needed; this may cause the updates to time out.

See also [[Qt:Документация 4.3.2/qsqlrelationaltablemodel | QSqlRelationalTableModel]], [[Qt:Документация 4.3.2/qsqlquery | QSqlQuery]], [[Qt:Документация 4.3.2/model-view-programming | Model/View Programming]], [[Qt:Документация 4.3.2/sql-tablemodel | Table Model Example]], and [[Qt:Документация 4.3.2/sql-cachedtable | Cached Table Example]].
<hr />
==Описание типов членов==

===<div id="EditStrategy-enum"></div>enum QSqlTableModel::EditStrategy===

This enum type describes which strategy to choose when editing values in the database.


{| border="1" cellpadding="2" cellspacing="1" width="100%"

|-
! width="25%" | Constant
! width="15%" | Value
! width="60%" | Description
|-
| valign="top" | <tt>QSqlTableModel::OnFieldChange</tt>
| align="center" valign="top" | <tt>0</tt>
| valign="top" | All changes to the model will be applied immediately to the database.
|-
| valign="top" | <tt>QSqlTableModel::OnRowChange</tt>
| align="center" valign="top" | <tt>1</tt>
| valign="top" | Changes to a row will be applied when the user selects a different row.
|-
| valign="top" | <tt>QSqlTableModel::OnManualSubmit</tt>
| align="center" valign="top" | <tt>2</tt>
| valign="top" | All changes will be cached in the model until either [[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]]() or [[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]]() is called.
|}

Note: To prevent inserting only partly initialized rows into the database, <tt>OnFieldChange</tt> will behave like <tt>OnRowChange</tt> for newly inserted rows.

See also [[Qt:Документация 4.3.2/qsqltablemodel#setEditStrategy | setEditStrategy]]().
<hr />
==Описание функций-членов==

===<div id="QSqlTableModel"></div>QSqlTableModel::QSqlTableModel ( [[Qt:Документация 4.3.2/qobject | QObject]] * ''parent'' = 0, [[Qt:Документация 4.3.2/qsqldatabase | QSqlDatabase]] ''db'' = QSqlDatabase() )===

Creates an empty [[Qt:Документация 4.3.2/qsqltablemodel | QSqlTableModel]] and sets the parent to ''parent'' and the database connection to ''db''. If ''db'' is not valid, the default database connection will be used.

The default edit strategy is [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnRowChange]].

===<div id="dtor.QSqlTableModel"></div>QSqlTableModel::~QSqlTableModel ()  <tt> [virtual]</tt>===

Destroys the object and frees any allocated resources.

===<div id="beforeDelete"></div>void QSqlTableModel::beforeDelete ( int ''row'' )  <tt> [signal]</tt>===

This signal is emitted before the ''row'' is deleted.

===<div id="beforeInsert"></div>void QSqlTableModel::beforeInsert ( [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] &amp; ''record'' )  <tt> [signal]</tt>===

This signal is emitted before a new row is inserted. The values that are about to be inserted are stored in ''record'' and can be modified before they will be inserted.

===<div id="beforeUpdate"></div>void QSqlTableModel::beforeUpdate ( int ''row'', [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] &amp; ''record'' )  <tt> [signal]</tt>===

This signal is emitted before the ''row'' is updated with the values from ''record''.

Note that only values that are marked as generated will be updated. The generated flag can be set with [[Qt:Документация 4.3.2/qsqlrecord#setGenerated | QSqlRecord::setGenerated]]() and checked with [[Qt:Документация 4.3.2/qsqlrecord#isGenerated | QSqlRecord::isGenerated]]().

See also [[Qt:Документация 4.3.2/qsqlrecord#isGenerated | QSqlRecord::isGenerated]]().

===<div id="database"></div>[[Qt:Документация 4.3.2/qsqldatabase | QSqlDatabase]] QSqlTableModel::database () const===

Returns a pointer to the used [[Qt:Документация 4.3.2/qsqldatabase | QSqlDatabase]] or 0 if no database was set.

===<div id="deleteRowFromTable"></div>bool QSqlTableModel::deleteRowFromTable ( int ''row'' )  <tt> [virtual protected]</tt>===

Deletes the given ''row'' from the currently active database table.

This is a low-level method that operates directly on the database and should not be called directly. Use [[Qt:Документация 4.3.2/qabstractitemmodel#removeRow | removeRow]]() or [[Qt:Документация 4.3.2/qsqltablemodel#removeRows | removeRows]]() to delete values. The model will decide depending on its edit strategy when to modify the database.

Returns true if the row was deleted; otherwise returns false.

See also [[Qt:Документация 4.3.2/qabstractitemmodel#removeRow | removeRow]]() and [[Qt:Документация 4.3.2/qsqltablemodel#removeRows | removeRows]]().

===<div id="editStrategy"></div>[[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | EditStrategy]] QSqlTableModel::editStrategy () const===

Returns the current edit strategy.

See also [[Qt:Документация 4.3.2/qsqltablemodel#setEditStrategy | setEditStrategy]]().

===<div id="fieldIndex"></div>int QSqlTableModel::fieldIndex ( const [[Qt:Документация 4.3.2/qstring | QString]] &amp; ''fieldName'' ) const===

Returns the index of the field ''fieldName''.

===<div id="filter"></div>[[Qt:Документация 4.3.2/qstring | QString]] QSqlTableModel::filter () const===

Returns the currently set filter.

See also [[Qt:Документация 4.3.2/qsqltablemodel#setFilter | setFilter]]() and [[Qt:Документация 4.3.2/qsqltablemodel#select | select]]().

===<div id="indexInQuery"></div>[[Qt:Документация 4.3.2/qmodelindex | QModelIndex]] QSqlTableModel::indexInQuery ( const [[Qt:Документация 4.3.2/qmodelindex | QModelIndex]] &amp; ''item'' ) const  <tt> [protected]</tt>===

Returns the index of the value in the database result set for the given ''item'' in the model.

The return value is identical to ''item'' if no columns or rows have been inserted, removed, or moved around.

Returns an invalid model index if ''item'' is out of bounds or if ''item'' does not point to a value in the result set.

See also [[Qt:Документация 4.3.2/qsqlquerymodel#indexInQuery | QSqlQueryModel::indexInQuery]]().

===<div id="insertRecord"></div>bool QSqlTableModel::insertRecord ( int ''row'', const [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] &amp; ''record'' )===

Inserts the ''record'' after ''row''. If ''row'' is negative, the record will be appended to the end. Calls [[Qt:Документация 4.3.2/qsqltablemodel#insertRows | insertRows]]() and [[Qt:Документация 4.3.2/qsqltablemodel#setRecord | setRecord]]() internally.

Returns true if the row could be inserted, otherwise false.

See also [[Qt:Документация 4.3.2/qsqltablemodel#insertRows | insertRows]]() and [[Qt:Документация 4.3.2/qsqltablemodel#removeRows | removeRows]]().

===<div id="insertRowIntoTable"></div>bool QSqlTableModel::insertRowIntoTable ( const [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] &amp; ''values'' )  <tt> [virtual protected]</tt>===

Inserts the values ''values'' into the currently active database table.

This is a low-level method that operates directly on the database and should not be called directly. Use [[Qt:Документация 4.3.2/qabstractitemmodel#insertRow | insertRow]]() and [[Qt:Документация 4.3.2/qsqltablemodel#setData | setData]]() to insert values. The model will decide depending on its edit strategy when to modify the database.

Returns true if the values could be inserted, otherwise false. Error information can be retrieved with [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]().

See also [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]](), [[Qt:Документация 4.3.2/qabstractitemmodel#insertRow | insertRow]](), and [[Qt:Документация 4.3.2/qsqltablemodel#insertRows | insertRows]]().

===<div id="insertRows"></div>bool QSqlTableModel::insertRows ( int ''row'', int ''count'', const [[Qt:Документация 4.3.2/qmodelindex | QModelIndex]] &amp; ''parent'' = QModelIndex() )  <tt> [virtual]</tt>===

Inserts ''count'' empty rows at position ''row''. Note that ''parent'' must be invalid, since this model does not support parent-child relations.

Only one row at a time can be inserted when using the [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnFieldChange]] or [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnRowChange]] update strategies.

The [[Qt:Документация 4.3.2/qsqltablemodel#primeInsert | primeInsert]]() signal will be emitted for each new row. Connect to it if you want to initialize the new row with default values.

Returns false if the parameters are out of bounds; otherwise returns true.

Reimplemented from [[Qt:Документация 4.3.2/qabstractitemmodel#insertRows | QAbstractItemModel]].

See also [[Qt:Документация 4.3.2/qsqltablemodel#primeInsert | primeInsert]]() and [[Qt:Документация 4.3.2/qsqltablemodel#insertRecord | insertRecord]]().

===<div id="isDirty"></div>bool QSqlTableModel::isDirty ( const [[Qt:Документация 4.3.2/qmodelindex | QModelIndex]] &amp; ''index'' ) const===

Returns true if the value at the index ''index'' is dirty, otherwise false. Dirty values are values that were modified in the model but not yet written into the database.

If ''index'' is invalid or points to a non-existing row, false is returned.

===<div id="orderByClause"></div>[[Qt:Документация 4.3.2/qstring | QString]] QSqlTableModel::orderByClause () const  <tt> [virtual protected]</tt>===

Returns an SQL <tt>ORDER BY</tt> clause based on the currently set sort order.

See also [[Qt:Документация 4.3.2/qsqltablemodel#setSort | setSort]]() and [[Qt:Документация 4.3.2/qsqltablemodel#selectStatement | selectStatement]]().

===<div id="primaryKey"></div>[[Qt:Документация 4.3.2/qsqlindex | QSqlIndex]] QSqlTableModel::primaryKey () const===

Returns the primary key for the current table, or an empty [[Qt:Документация 4.3.2/qsqlindex | QSqlIndex]] if the table is not set or has no primary key.

See also [[Qt:Документация 4.3.2/qsqltablemodel#setTable | setTable]](), [[Qt:Документация 4.3.2/qsqltablemodel#setPrimaryKey | setPrimaryKey]](), and [[Qt:Документация 4.3.2/qsqldatabase#primaryIndex | QSqlDatabase::primaryIndex]]().

===<div id="primeInsert"></div>void QSqlTableModel::primeInsert ( int ''row'', [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] &amp; ''record'' )  <tt> [signal]</tt>===

This signal is emitted when an insertion is initiated in the given ''row''. The ''record'' parameter can be written to (since it is a reference), for example to populate some fields with default values.

===<div id="removeColumns"></div>bool QSqlTableModel::removeColumns ( int ''column'', int ''count'', const [[Qt:Документация 4.3.2/qmodelindex | QModelIndex]] &amp; ''parent'' = QModelIndex() )  <tt> [virtual]</tt>===

Removes ''count'' columns from the ''parent'' model, starting at index ''column''.

Returns if the columns were successfully removed; otherwise returns false.

Reimplemented from [[Qt:Документация 4.3.2/qabstractitemmodel#removeColumns | QAbstractItemModel]].

See also [[Qt:Документация 4.3.2/qsqltablemodel#removeRows | removeRows]]().

===<div id="removeRows"></div>bool QSqlTableModel::removeRows ( int ''row'', int ''count'', const [[Qt:Документация 4.3.2/qmodelindex | QModelIndex]] &amp; ''parent'' = QModelIndex() )  <tt> [virtual]</tt>===

Removes ''count'' rows starting at ''row''. Since this model does not support hierarchical structures, ''parent'' must be an invalid model index.

Emits the [[Qt:Документация 4.3.2/qsqltablemodel#beforeDelete | beforeDelete]]() signal before a row is deleted.

Returns true if all rows could be removed; otherwise returns false. Detailed error information can be retrieved using [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]().

Reimplemented from [[Qt:Документация 4.3.2/qabstractitemmodel#removeRows | QAbstractItemModel]].

See also [[Qt:Документация 4.3.2/qsqltablemodel#removeColumns | removeColumns]]() and [[Qt:Документация 4.3.2/qsqltablemodel#insertRows | insertRows]]().

===<div id="revert"></div>void QSqlTableModel::revert ()  <tt> [virtual slot]</tt>===

This reimplemented slot is called by the item delegates when the user canceled editing the current row.

Reverts the changes if the model's strategy is set to [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnRowChange]]. Does nothing for the other edit strategies.

Use [[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]]() to revert all pending changes for the [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnManualSubmit]] strategy or [[Qt:Документация 4.3.2/qsqltablemodel#revertRow | revertRow]]() to revert a specific row.

Reimplemented from [[Qt:Документация 4.3.2/qabstractitemmodel#revert | QAbstractItemModel]].

See also [[Qt:Документация 4.3.2/qsqltablemodel#submit | submit]](), [[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]](), [[Qt:Документация 4.3.2/qsqltablemodel#revertRow | revertRow]](), and [[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]]().

===<div id="revertAll"></div>void QSqlTableModel::revertAll ()  <tt> [slot]</tt>===

Reverts all pending changes.

See also [[Qt:Документация 4.3.2/qsqltablemodel#revert | revert]](), [[Qt:Документация 4.3.2/qsqltablemodel#revertRow | revertRow]](), and [[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]]().

===<div id="revertRow"></div>void QSqlTableModel::revertRow ( int ''row'' )  <tt> [virtual]</tt>===

Reverts all changes for the specified ''row''.

See also [[Qt:Документация 4.3.2/qsqltablemodel#revert | revert]](), [[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]](), [[Qt:Документация 4.3.2/qsqltablemodel#submit | submit]](), and [[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]]().

===<div id="select"></div>bool QSqlTableModel::select ()  <tt> [virtual]</tt>===

Populates the model with data from the table that was set via [[Qt:Документация 4.3.2/qsqltablemodel#setTable | setTable]](), using the specified filter and sort condition, and returns true if successful; otherwise returns false.

See also [[Qt:Документация 4.3.2/qsqltablemodel#setTable | setTable]](), [[Qt:Документация 4.3.2/qsqltablemodel#setFilter | setFilter]](), and [[Qt:Документация 4.3.2/qsqltablemodel#selectStatement | selectStatement]]().

===<div id="selectStatement"></div>[[Qt:Документация 4.3.2/qstring | QString]] QSqlTableModel::selectStatement () const  <tt> [virtual protected]</tt>===

Returns the SQL <tt>SELECT</tt> statement used internally to populate the model. The statement includes the filter and the <tt>ORDER BY</tt> clause.

See also [[Qt:Документация 4.3.2/qsqltablemodel#filter | filter]]() and [[Qt:Документация 4.3.2/qsqltablemodel#orderByClause | orderByClause]]().

===<div id="setData"></div>bool QSqlTableModel::setData ( const [[Qt:Документация 4.3.2/qmodelindex | QModelIndex]] &amp; ''index'', const [[Qt:Документация 4.3.2/qvariant | QVariant]] &amp; ''value'', int ''role'' = Qt::EditRole )  <tt> [virtual]</tt>===

Sets the data for the item ''index'' for the role ''role'' to ''value''. Depending on the edit strategy, the value might be applied to the database at once or cached in the model.

Returns true if the value could be set or false on error, for example if ''index'' is out of bounds.

Reimplemented from [[Qt:Документация 4.3.2/qabstractitemmodel#setData | QAbstractItemModel]].

See also [[Qt:Документация 4.3.2/qsqltablemodel#editStrategy | editStrategy]](), [[Qt:Документация 4.3.2/qabstractitemmodel#data | data]](), [[Qt:Документация 4.3.2/qsqltablemodel#submit | submit]](), [[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]](), and [[Qt:Документация 4.3.2/qsqltablemodel#revertRow | revertRow]]().

===<div id="setEditStrategy"></div>void QSqlTableModel::setEditStrategy ( [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | EditStrategy]] ''strategy'' )  <tt> [virtual]</tt>===

Sets the strategy for editing values in the database to ''strategy''.

This will revert any pending changes.

See also [[Qt:Документация 4.3.2/qsqltablemodel#editStrategy | editStrategy]]() and [[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]]().

===<div id="setFilter"></div>void QSqlTableModel::setFilter ( const [[Qt:Документация 4.3.2/qstring | QString]] &amp; ''filter'' )  <tt> [virtual]</tt>===

Sets the current filter to ''filter''.

The filter is a SQL <tt>WHERE</tt> clause without the keyword <tt>WHERE</tt> (for example, <tt>name='Josephine')</tt>.

If the model is already populated with data from a database, the model re-selects it with the new filter. Otherwise, the filter will be applied the next time [[Qt:Документация 4.3.2/qsqltablemodel#select | select]]() is called.

See also [[Qt:Документация 4.3.2/qsqltablemodel#filter | filter]](), [[Qt:Документация 4.3.2/qsqltablemodel#select | select]](), [[Qt:Документация 4.3.2/qsqltablemodel#selectStatement | selectStatement]](), and [[Qt:Документация 4.3.2/qsqltablemodel#orderByClause | orderByClause]]().

===<div id="setPrimaryKey"></div>void QSqlTableModel::setPrimaryKey ( const [[Qt:Документация 4.3.2/qsqlindex | QSqlIndex]] &amp; ''key'' )  <tt> [protected]</tt>===

Protected method that allows subclasses to set the primary key to ''key''.

Normally, the primary index is set automatically whenever you call [[Qt:Документация 4.3.2/qsqltablemodel#setTable | setTable]]().

See also [[Qt:Документация 4.3.2/qsqltablemodel#primaryKey | primaryKey]]() and [[Qt:Документация 4.3.2/qsqldatabase#primaryIndex | QSqlDatabase::primaryIndex]]().

===<div id="setQuery"></div>void QSqlTableModel::setQuery ( const [[Qt:Документация 4.3.2/qsqlquery | QSqlQuery]] &amp; ''query'' )  <tt> [protected]</tt>===

This function simply calls QSqlQueryModel::setQuery(''query''). You should normally not call it on a [[Qt:Документация 4.3.2/qsqltablemodel | QSqlTableModel]]. Instead, use [[Qt:Документация 4.3.2/qsqltablemodel#setTable | setTable]](), [[Qt:Документация 4.3.2/qsqltablemodel#setSort | setSort]](), [[Qt:Документация 4.3.2/qsqltablemodel#setFilter | setFilter]](), etc., to set up the query.

See also [[Qt:Документация 4.3.2/qsqltablemodel#selectStatement | selectStatement]]().

===<div id="setRecord"></div>bool QSqlTableModel::setRecord ( int ''row'', const [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] &amp; ''record'' )===

Sets the values at the specified ''row'' to the values of ''record''. Returns true if all the values could be set; otherwise returns false.

See also [[Qt:Документация 4.3.2/qsqlquerymodel#record | record]]().

===<div id="setSort"></div>void QSqlTableModel::setSort ( int ''column'', [[Qt:Документация 4.3.2/qt#SortOrder-enum | Qt::SortOrder]] ''order'' )  <tt> [virtual]</tt>===

Sets the sort order for ''column'' to ''order''. This does not affect the current data, to refresh the data using the new sort order, call [[Qt:Документация 4.3.2/qsqltablemodel#select | select]]().

See also [[Qt:Документация 4.3.2/qsqltablemodel#sort | sort]](), [[Qt:Документация 4.3.2/qsqltablemodel#select | select]](), and [[Qt:Документация 4.3.2/qsqltablemodel#orderByClause | orderByClause]]().

===<div id="setTable"></div>void QSqlTableModel::setTable ( const [[Qt:Документация 4.3.2/qstring | QString]] &amp; ''tableName'' )  <tt> [virtual]</tt>===

Sets the database table on which the model operates to ''tableName''. Does not select data from the table, but fetches its field information.

To populate the model with the table's data, call [[Qt:Документация 4.3.2/qsqltablemodel#select | select]]().

Error information can be retrieved with [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]().

See also [[Qt:Документация 4.3.2/qsqltablemodel#select | select]](), [[Qt:Документация 4.3.2/qsqltablemodel#setFilter | setFilter]](), and [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]().

===<div id="sort"></div>void QSqlTableModel::sort ( int ''column'', [[Qt:Документация 4.3.2/qt#SortOrder-enum | Qt::SortOrder]] ''order'' )  <tt> [virtual]</tt>===

Sorts the data by ''column'' with the sort order ''order''. This will immediately select data, use [[Qt:Документация 4.3.2/qsqltablemodel#setSort | setSort]]() to set a sort order without populating the model with data.

Reimplemented from [[Qt:Документация 4.3.2/qabstractitemmodel#sort | QAbstractItemModel]].

See also [[Qt:Документация 4.3.2/qsqltablemodel#setSort | setSort]](), [[Qt:Документация 4.3.2/qsqltablemodel#select | select]](), and [[Qt:Документация 4.3.2/qsqltablemodel#orderByClause | orderByClause]]().

===<div id="submit"></div>bool QSqlTableModel::submit ()  <tt> [virtual slot]</tt>===

This reimplemented slot is called by the item delegates when the user stopped editing the current row.

Submits the currently edited row if the model's strategy is set to [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnRowChange]] or [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnFieldChange]]. Does nothing for the [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnManualSubmit]] strategy.

Use [[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]]() to submit all pending changes for the [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnManualSubmit]] strategy.

Returns true on success; otherwise returns false. Use [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]() to query detailed error information.

On success the model will be repopulated. Any views presenting it will lose their selections.

Reimplemented from [[Qt:Документация 4.3.2/qabstractitemmodel#submit | QAbstractItemModel]].

See also [[Qt:Документация 4.3.2/qsqltablemodel#revert | revert]](), [[Qt:Документация 4.3.2/qsqltablemodel#revertRow | revertRow]](), [[Qt:Документация 4.3.2/qsqltablemodel#submitAll | submitAll]](), [[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]](), and [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]().

===<div id="submitAll"></div>bool QSqlTableModel::submitAll ()  <tt> [slot]</tt>===

Submits all pending changes and returns true on success. Returns false on error, detailed error information can be obtained with [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]().

On success the model will be repopulated. Any views presenting it will lose their selections.

Note: In [[Qt:Документация 4.3.2/qsqltablemodel#EditStrategy-enum | OnManualSubmit]] mode, already submitted changes won't be cleared from the cache when submitAll() fails. This allows transactions to be rolled back and resubmitted again without losing data.

See also [[Qt:Документация 4.3.2/qsqltablemodel#revertAll | revertAll]]() and [[Qt:Документация 4.3.2/qsqlquerymodel#lastError | lastError]]().

===<div id="tableName"></div>[[Qt:Документация 4.3.2/qstring | QString]] QSqlTableModel::tableName () const===

Returns the name of the currently selected table.

===<div id="updateRowInTable"></div>bool QSqlTableModel::updateRowInTable ( int ''row'', const [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] &amp; ''values'' )  <tt> [virtual protected]</tt>===

Updates the given ''row'' in the currently active database table with the specified ''values''. Returns true if successful; otherwise returns false.

This is a low-level method that operates directly on the database and should not be called directly. Use [[Qt:Документация 4.3.2/qsqltablemodel#setData | setData]]() to update values. The model will decide depending on its edit strategy when to modify the database.

Note that only values that have the generated-flag set are updated. The generated-flag can be set with [[Qt:Документация 4.3.2/qsqlrecord#setGenerated | QSqlRecord::setGenerated]]() and tested with [[Qt:Документация 4.3.2/qsqlrecord#isGenerated | QSqlRecord::isGenerated]]().

See also [[Qt:Документация 4.3.2/qsqlrecord#isGenerated | QSqlRecord::isGenerated]]() and [[Qt:Документация 4.3.2/qsqltablemodel#setData | setData]]().

{{Qt4.3.2_footer}}