Редактирование Qt:Документация 4.3.2/q3databrowser (раздел)

=Q3DataBrowser Class Reference<br /><sup><sup> [ [[Qt:Документация 4.3.2/qt3support | Qt3Support]] module]</sup></sup>=

The Q3DataBrowser class provides data manipulation and navigation for data entry forms. [[#details | Далее...]]
<source lang="cpp-qt"> #include <Q3DataBrowser></source> 
'''This class is part of the Qt 3 support library.''' It is provided to keep old source code working. Мы настоятельно не рекомендуем использовать этот класс в новом коде. See [[Qt:Документация 4.3.2/porting4#qdatabrowser | Porting to Qt 4]] for more information.

'''Note to Qt Desktop Light Edition users:''' This class is only available in the [[Qt:Документация 4.3.2/commercialeditions#qt-desktop-edition | Qt Desktop Edition]].

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

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

*enum '''[[Qt:Документация 4.3.2/q3databrowser#Boundary-enum | Boundary]]''' { Unknown, None, BeforeBeginning, Beginning, End, AfterEnd }
<div id="properties"></div>
===Свойства===


{| width="100%" border="0" cellpadding="0" cellspacing="0"

|-
| width="45%" valign="top" | 
*'''[[Qt:Документация 4.3.2/q3databrowser#autoEdit-prop | autoEdit]]''' : bool
*'''[[Qt:Документация 4.3.2/q3databrowser#boundaryChecking-prop | boundaryChecking]]''' : bool
*'''[[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | confirmCancels]]''' : bool
*'''[[Qt:Документация 4.3.2/q3databrowser#confirmDelete-prop | confirmDelete]]''' : bool
*'''[[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | confirmEdits]]''' : bool

| valign="top" | 
*'''[[Qt:Документация 4.3.2/q3databrowser#confirmInsert-prop | confirmInsert]]''' : bool
*'''[[Qt:Документация 4.3.2/q3databrowser#confirmUpdate-prop | confirmUpdate]]''' : bool
*'''[[Qt:Документация 4.3.2/q3databrowser#filter-prop | filter]]''' : QString
*'''[[Qt:Документация 4.3.2/q3databrowser#readOnly-prop | readOnly]]''' : bool
*'''[[Qt:Документация 4.3.2/q3databrowser#sort-prop | sort]]''' : QStringList

|}

*56 свойств, унаследованных от [[Qt:Документация 4.3.2/qwidget#properties | QWidget]]
*1 свойство, унаследованное от [[Qt:Документация 4.3.2/qobject#properties | QObject]]
<div id="public-functions"></div>
===Открытые функции===

*'''[[Qt:Документация 4.3.2/q3databrowser#Q3DataBrowser | Q3DataBrowser]]''' ( QWidget * ''parent'' = 0, const char * ''name'' = 0, Qt::WindowFlags ''fl'' = 0 )
*'''[[Qt:Документация 4.3.2/q3databrowser#dtor.Q3DataBrowser | ~Q3DataBrowser]]''' ()
*bool '''[[Qt:Документация 4.3.2/q3databrowser#autoEdit-prop | autoEdit]]''' () const
*Boundary '''[[Qt:Документация 4.3.2/q3databrowser#boundary | boundary]]''' ()
*bool '''[[Qt:Документация 4.3.2/q3databrowser#boundaryChecking-prop | boundaryChecking]]''' () const
*bool '''[[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | confirmCancels]]''' () const
*bool '''[[Qt:Документация 4.3.2/q3databrowser#confirmDelete-prop | confirmDelete]]''' () const
*bool '''[[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | confirmEdits]]''' () const
*bool '''[[Qt:Документация 4.3.2/q3databrowser#confirmInsert-prop | confirmInsert]]''' () const
*bool '''[[Qt:Документация 4.3.2/q3databrowser#confirmUpdate-prop | confirmUpdate]]''' () const
*QString '''[[Qt:Документация 4.3.2/q3databrowser#filter-prop | filter]]''' () const
*Q3SqlForm * '''[[Qt:Документация 4.3.2/q3databrowser#form | form]]''' ()
*bool '''[[Qt:Документация 4.3.2/q3databrowser#readOnly-prop | isReadOnly]]''' () const
*virtual bool '''[[Qt:Документация 4.3.2/q3databrowser#seek | seek]]''' ( int ''i'', bool ''relative'' = false )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#autoEdit-prop | setAutoEdit]]''' ( bool ''autoEdit'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#boundaryChecking-prop | setBoundaryChecking]]''' ( bool ''active'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | setConfirmCancels]]''' ( bool ''confirm'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#confirmDelete-prop | setConfirmDelete]]''' ( bool ''confirm'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | setConfirmEdits]]''' ( bool ''confirm'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#confirmInsert-prop | setConfirmInsert]]''' ( bool ''confirm'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#confirmUpdate-prop | setConfirmUpdate]]''' ( bool ''confirm'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#filter-prop | setFilter]]''' ( const QString &amp; ''filter'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#setForm | setForm]]''' ( Q3SqlForm * ''form'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#readOnly-prop | setReadOnly]]''' ( bool ''active'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#sort-prop | setSort]]''' ( const QStringList &amp; ''sort'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#sort-prop | setSort]]''' ( const QSqlIndex &amp; ''sort'' )
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#setSqlCursor | setSqlCursor]]''' ( Q3SqlCursor * ''cursor'', bool ''autoDelete'' = false )
*QStringList '''[[Qt:Документация 4.3.2/q3databrowser#sort-prop | sort]]''' () const
*Q3SqlCursor * '''[[Qt:Документация 4.3.2/q3databrowser#sqlCursor | sqlCursor]]''' () const

*201 свойство, унаследованное от [[Qt:Документация 4.3.2/qwidget#public-functions | QWidget]]
*29 открытых функций, унаследованных от [[Qt:Документация 4.3.2/qobject#public-functions | QObject]]
*12 открытых функций, унаследованных от [[Qt:Документация 4.3.2/qpaintdevice#public-functions | QPaintDevice]]
<div id="public-slots"></div>
===Открытые слоты===

*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#clearValues | clearValues]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#del | del]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#first | first]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#insert | insert]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#last | last]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#next | next]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#prev | prev]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#readFields | readFields]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#refresh | refresh]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#update | update]]''' ()
*void '''[[Qt:Документация 4.3.2/q3databrowser#updateBoundary | updateBoundary]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#writeFields | writeFields]]''' ()

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

*void '''[[Qt:Документация 4.3.2/q3databrowser#beforeDelete | beforeDelete]]''' ( QSqlRecord * ''buf'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#beforeInsert | beforeInsert]]''' ( QSqlRecord * ''buf'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#beforeUpdate | beforeUpdate]]''' ( QSqlRecord * ''buf'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#currentChanged | currentChanged]]''' ( const QSqlRecord * ''record'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#cursorChanged | cursorChanged]]''' ( Q3SqlCursor::Mode ''mode'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#firstRecordAvailable | firstRecordAvailable]]''' ( bool ''available'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#lastRecordAvailable | lastRecordAvailable]]''' ( bool ''available'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#nextRecordAvailable | nextRecordAvailable]]''' ( bool ''available'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#prevRecordAvailable | prevRecordAvailable]]''' ( bool ''available'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#primeDelete | primeDelete]]''' ( QSqlRecord * ''buf'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#primeInsert | primeInsert]]''' ( QSqlRecord * ''buf'' )
*void '''[[Qt:Документация 4.3.2/q3databrowser#primeUpdate | primeUpdate]]''' ( QSqlRecord * ''buf'' )

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

*virtual QSql::Confirm '''[[Qt:Документация 4.3.2/q3databrowser#confirmCancel | confirmCancel]]''' ( QSql::Op ''m'' )
*virtual QSql::Confirm '''[[Qt:Документация 4.3.2/q3databrowser#confirmEdit | confirmEdit]]''' ( QSql::Op ''m'' )
*virtual bool '''[[Qt:Документация 4.3.2/q3databrowser#currentEdited | currentEdited]]''' ()
*virtual bool '''[[Qt:Документация 4.3.2/q3databrowser#deleteCurrent | deleteCurrent]]''' ()
*virtual void '''[[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]''' ( const QSqlError &amp; ''error'' )
*virtual bool '''[[Qt:Документация 4.3.2/q3databrowser#insertCurrent | insertCurrent]]''' ()
*virtual bool '''[[Qt:Документация 4.3.2/q3databrowser#updateCurrent | updateCurrent]]''' ()

*38 защищенных функций, унаследованных от [[Qt:Документация 4.3.2/qwidget#protected-functions | QWidget]]
*7 защищенных функций, унаследованных от [[Qt:Документация 4.3.2/qobject#protected-functions | QObject]]
*1 защищенная функция, унаследованных от [[Qt:Документация 4.3.2/qpaintdevice#protected-functions | QPaintDevice]]

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

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

The Q3DataBrowser class provides data manipulation and navigation for data entry forms.

A high-level API is provided for navigating through data records in a cursor, for inserting, updating and deleting records, and for refreshing data in the display.

If you want a read-only form to present database data use [[Qt:Документация 4.3.2/q3dataview | Q3DataView]]; if you want a table-based presentation of your data use [[Qt:Документация 4.3.2/q3datatable | Q3DataTable]].

A Q3DataBrowser is used to associate a dataset with a form in much the same way as a [[Qt:Документация 4.3.2/q3datatable | Q3DataTable]] associates a dataset with a table. Once the data browser has been constructed it can be associated with a dataset with [[Qt:Документация 4.3.2/q3databrowser#setSqlCursor | setSqlCursor]](), and with a form with [[Qt:Документация 4.3.2/q3databrowser#setForm | setForm]](). Boundary checking, sorting and filtering can be set with [[Qt:Документация 4.3.2/q3databrowser#boundaryChecking-prop | setBoundaryChecking]](), [[Qt:Документация 4.3.2/q3databrowser#sort-prop | setSort]]() and [[Qt:Документация 4.3.2/q3databrowser#filter-prop | setFilter]](), respectively.

The [[Qt:Документация 4.3.2/q3databrowser#insertCurrent | insertCurrent]]() function reads the fields from the default form into the default cursor and performs the insert. The [[Qt:Документация 4.3.2/q3databrowser#updateCurrent | updateCurrent]]() and [[Qt:Документация 4.3.2/q3databrowser#deleteCurrent | deleteCurrent]]() functions perform similarly to update and delete the current record respectively.

The user can be asked to confirm all edits with [[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | setConfirmEdits]](). For more precise control use [[Qt:Документация 4.3.2/q3databrowser#confirmInsert-prop | setConfirmInsert]](), [[Qt:Документация 4.3.2/q3databrowser#confirmUpdate-prop | setConfirmUpdate]](), [[Qt:Документация 4.3.2/q3databrowser#confirmDelete-prop | setConfirmDelete]]() and [[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | setConfirmCancels]](). Use [[Qt:Документация 4.3.2/q3databrowser#autoEdit-prop | setAutoEdit]]() to control the behavior of the form when the user edits a record and then navigates.

The record set is navigated using [[Qt:Документация 4.3.2/q3databrowser#first | first]](), [[Qt:Документация 4.3.2/q3databrowser#next | next]](), [[Qt:Документация 4.3.2/q3databrowser#prev | prev]](), [[Qt:Документация 4.3.2/q3databrowser#last | last]]() and [[Qt:Документация 4.3.2/q3databrowser#seek | seek]](). The form's display is updated with [[Qt:Документация 4.3.2/q3databrowser#refresh | refresh]](). When navigation takes place the [[Qt:Документация 4.3.2/q3databrowser#firstRecordAvailable | firstRecordAvailable]](), [[Qt:Документация 4.3.2/q3databrowser#lastRecordAvailable | lastRecordAvailable]](), [[Qt:Документация 4.3.2/q3databrowser#nextRecordAvailable | nextRecordAvailable]]() and [[Qt:Документация 4.3.2/q3databrowser#prevRecordAvailable | prevRecordAvailable]]() signals are emitted. When the cursor record is changed due to navigation the [[Qt:Документация 4.3.2/q3databrowser#cursorChanged | cursorChanged]]() signal is emitted.

If you want finer control of the insert, update and delete processes then you can use the lower level functions to perform these operations as described below.

The form is populated with data from the database with [[Qt:Документация 4.3.2/q3databrowser#readFields | readFields]](). If the user is allowed to edit, (see [[Qt:Документация 4.3.2/q3databrowser#readOnly-prop | setReadOnly]]()), write the form's data back to the cursor's edit buffer with [[Qt:Документация 4.3.2/q3databrowser#writeFields | writeFields]](). You can clear the values in the form with [[Qt:Документация 4.3.2/q3databrowser#clearValues | clearValues]](). Editing is performed as follows:

*''insert'' When the data browser enters insertion mode it emits the [[Qt:Документация 4.3.2/q3databrowser#primeInsert | primeInsert]]() signal which you can connect to, for example to pre-populate fields. Call [[Qt:Документация 4.3.2/q3databrowser#writeFields | writeFields]]() to write the user's edits to the cursor's edit buffer then call [[Qt:Документация 4.3.2/q3databrowser#insert | insert]]() to insert the record into the database. The [[Qt:Документация 4.3.2/q3databrowser#beforeInsert | beforeInsert]]() signal is emitted just before the cursor's edit buffer is inserted into the database; connect to this for example, to populate fields such as an auto-generated primary key.
*''update'' For updates the [[Qt:Документация 4.3.2/q3databrowser#primeUpdate | primeUpdate]]() signal is emitted when the data browser enters update mode. After calling [[Qt:Документация 4.3.2/q3databrowser#writeFields | writeFields]]() call [[Qt:Документация 4.3.2/q3databrowser#update | update]]() to update the record and connect to the [[Qt:Документация 4.3.2/q3databrowser#beforeUpdate | beforeUpdate]]() signal to manipulate the user's data before the update takes place.
*''delete'' For deletion the [[Qt:Документация 4.3.2/q3databrowser#primeDelete | primeDelete]]() signal is emitted when the data browser enters deletion mode. After calling [[Qt:Документация 4.3.2/q3databrowser#writeFields | writeFields]]() call [[Qt:Документация 4.3.2/q3databrowser#del | del]]() to delete the record and connect to the [[Qt:Документация 4.3.2/q3databrowser#beforeDelete | beforeDelete]]() signal, for example to record an audit of the deleted record.
<hr />
==Описание типов==

===<div id="Boundary-enum"></div>enum Q3DataBrowser::Boundary===

This enum describes where the data browser is positioned.


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

|-
! width="25%" | Константа
! width="15%" | Значение
! width="60%" | Описание
|-
| valign="top" | <tt>Q3DataBrowser::Unknown</tt>
| align="center" valign="top" | <tt>0</tt>
| valign="top" | the boundary cannot be determined (usually because there is no default cursor, or the default cursor is not active).
|-
| valign="top" | <tt>Q3DataBrowser::None</tt>
| align="center" valign="top" | <tt>1</tt>
| valign="top" | the browser is not positioned on a boundary, but it is positioned on a record somewhere in the middle.
|-
| valign="top" | <tt>Q3DataBrowser::BeforeBeginning</tt>
| align="center" valign="top" | <tt>2</tt>
| valign="top" | the browser is positioned before the first available record.
|-
| valign="top" | <tt>Q3DataBrowser::Beginning</tt>
| align="center" valign="top" | <tt>3</tt>
| valign="top" | the browser is positioned at the first record.
|-
| valign="top" | <tt>Q3DataBrowser::End</tt>
| align="center" valign="top" | <tt>4</tt>
| valign="top" | the browser is positioned at the last record.
|-
| valign="top" | <tt>Q3DataBrowser::AfterEnd</tt>
| align="center" valign="top" | <tt>5</tt>
| valign="top" | the browser is positioned after the last available record.
|}
<hr />
==Описание cвойств==

===<div id="autoEdit-prop"></div>autoEdit : bool===

This property holds whether the browser automatically applies edits.

The default value for this property is true. When the user begins an insertion or an update on a form there are two possible outcomes when they navigate to another record:

*the insert or update is is performed -- this occurs if autoEdit is true
*the insert or update is discarded -- this occurs if autoEdit is false

Функции доступа:

*'''bool autoEdit () const'''
*'''virtual void setAutoEdit ( bool ''autoEdit'' )'''

===<div id="boundaryChecking-prop"></div>boundaryChecking : bool===

This property holds whether boundary checking is active.

When boundary checking is active (the default), signals are emitted indicating the current position of the default cursor.

Функции доступа:

*'''bool boundaryChecking () const'''
*'''void setBoundaryChecking ( bool ''active'' )'''

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

===<div id="confirmCancels-prop"></div>confirmCancels : bool===

This property holds whether the browser confirms cancel operations.

If this property is true, all cancels must be confirmed by the user through a message box (this behavior can be changed by overriding the [[Qt:Документация 4.3.2/q3databrowser#confirmCancel | confirmCancel]]() function), otherwise all cancels occur immediately. По умолчанию равно false.

Функции доступа:

*'''bool confirmCancels () const'''
*'''virtual void setConfirmCancels ( bool ''confirm'' )'''

See also [[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | confirmEdits]]() and [[Qt:Документация 4.3.2/q3databrowser#confirmCancel | confirmCancel]]().

===<div id="confirmDelete-prop"></div>confirmDelete : bool===

This property holds whether the browser confirms deletions.

If this property is true, the browser confirms deletions, otherwise deletions happen immediately.

Функции доступа:

*'''bool confirmDelete () const'''
*'''virtual void setConfirmDelete ( bool ''confirm'' )'''

See also [[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | confirmCancels]](), [[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | confirmEdits]](), [[Qt:Документация 4.3.2/q3databrowser#confirmUpdate-prop | confirmUpdate]](), [[Qt:Документация 4.3.2/q3databrowser#confirmInsert-prop | confirmInsert]](), and [[Qt:Документация 4.3.2/q3databrowser#confirmEdit | confirmEdit]]().

===<div id="confirmEdits-prop"></div>confirmEdits : bool===

This property holds whether the browser confirms edits.

If this property is true, the browser confirms all edit operations (insertions, updates and deletions), otherwise all edit operations happen immediately. Confirmation is achieved by presenting the user with a message box -- this behavior can be changed by reimplementing the [[Qt:Документация 4.3.2/q3databrowser#confirmEdit | confirmEdit]]() function,

Функции доступа:

*'''bool confirmEdits () const'''
*'''virtual void setConfirmEdits ( bool ''confirm'' )'''

See also [[Qt:Документация 4.3.2/q3databrowser#confirmEdit | confirmEdit]](), [[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | confirmCancels]](), [[Qt:Документация 4.3.2/q3databrowser#confirmInsert-prop | confirmInsert]](), [[Qt:Документация 4.3.2/q3databrowser#confirmUpdate-prop | confirmUpdate]](), and [[Qt:Документация 4.3.2/q3databrowser#confirmDelete-prop | confirmDelete]]().

===<div id="confirmInsert-prop"></div>confirmInsert : bool===

This property holds whether the data browser confirms insertions.

If this property is true, the browser confirms insertions, otherwise insertions happen immediately.

Функции доступа:

*'''bool confirmInsert () const'''
*'''virtual void setConfirmInsert ( bool ''confirm'' )'''

See also [[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | confirmCancels]](), [[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | confirmEdits]](), [[Qt:Документация 4.3.2/q3databrowser#confirmUpdate-prop | confirmUpdate]](), [[Qt:Документация 4.3.2/q3databrowser#confirmDelete-prop | confirmDelete]](), and [[Qt:Документация 4.3.2/q3databrowser#confirmEdit | confirmEdit]]().

===<div id="confirmUpdate-prop"></div>confirmUpdate : bool===

This property holds whether the browser confirms updates.

If this property is true, the browser confirms updates, otherwise updates happen immediately.

Функции доступа:

*'''bool confirmUpdate () const'''
*'''virtual void setConfirmUpdate ( bool ''confirm'' )'''

See also [[Qt:Документация 4.3.2/q3databrowser#confirmCancels-prop | confirmCancels]](), [[Qt:Документация 4.3.2/q3databrowser#confirmEdits-prop | confirmEdits]](), [[Qt:Документация 4.3.2/q3databrowser#confirmInsert-prop | confirmInsert]](), [[Qt:Документация 4.3.2/q3databrowser#confirmDelete-prop | confirmDelete]](), and [[Qt:Документация 4.3.2/q3databrowser#confirmEdit | confirmEdit]]().

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

This property holds the data browser's filter.

The filter applies to the data shown in the browser. Call [[Qt:Документация 4.3.2/q3databrowser#refresh | refresh]]() to apply the new filter. A filter is a string containing a SQL WHERE clause without the WHERE keyword, e.g. "id>1000", "name LIKE 'A%'", etc.

There is no default filter.

Функции доступа:

*'''QString filter () const'''
*'''void setFilter ( const QString &amp; ''filter'' )'''

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

===<div id="readOnly-prop"></div>readOnly : bool===

This property holds whether the browser is read-only.

The default is false, i.e. data can be edited. If the data browser is read-only, no database edits will be allowed.

Функции доступа:

*'''bool isReadOnly () const'''
*'''virtual void setReadOnly ( bool ''active'' )'''

===<div id="sort-prop"></div>sort : [[Qt:Документация 4.3.2/qstringlist | QStringList]]===

This property holds the data browser's sort.

The data browser's sort affects the order in which records are viewed in the browser. Call [[Qt:Документация 4.3.2/q3databrowser#refresh | refresh]]() to apply the new sort.

When retrieving the sort property, a string list is returned in the form 'fieldname order', e.g. 'id ASC', 'surname DESC'.

There is no default sort.

Note that if you want to iterate over the list, you should iterate over a copy, e.g.
<source lang="cpp-qt"> QStringList list = myDataBrowser.sort();
 QStringList::Iterator it = list.begin();
 while(it != list.end()) {
     myProcessing(*it);
     ++it;
 }</source> 
Функции доступа:

*'''QStringList sort () const'''
*'''void setSort ( const QSqlIndex &amp; ''sort'' )'''
*'''void setSort ( const QStringList &amp; ''sort'' )'''
<hr />
==Описание функций-членов==

===<div id="Q3DataBrowser"></div>Q3DataBrowser::Q3DataBrowser ( [[Qt:Документация 4.3.2/qwidget | QWidget]] * ''parent'' = 0, const char * ''name'' = 0, [[Qt:Документация 4.3.2/qt#WindowType-enum | Qt::WindowFlags]] ''fl'' = 0 )===

Constructs a data browser which is a child of ''parent'', with the name ''name'' and widget flags set to ''fl''.

===<div id="dtor.Q3DataBrowser"></div>Q3DataBrowser::~Q3DataBrowser ()===

Удаляет объект и очищает любые выделенные ресурсы.

===<div id="beforeDelete"></div>void Q3DataBrowser::beforeDelete ( [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] * ''buf'' )  <tt> [signal]</tt>===

This signal is emitted just before the cursor's edit buffer is deleted from the database. The ''buf'' parameter points to the edit buffer being deleted. You might connect to this signal to capture some auditing information about the deletion.

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

This signal is emitted just before the cursor's edit buffer is inserted into the database. The ''buf'' parameter points to the edit buffer being inserted. You might connect to this signal to populate a generated primary key for example.

===<div id="beforeUpdate"></div>void Q3DataBrowser::beforeUpdate ( [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] * ''buf'' )  <tt> [signal]</tt>===

This signal is emitted just before the cursor's edit buffer is updated in the database. The ''buf'' parameter points to the edit buffer being updated. You might connect to this signal to capture some auditing information about the update.

===<div id="boundary"></div>[[Qt:Документация 4.3.2/q3databrowser#Boundary-enum | Boundary]] Q3DataBrowser::boundary ()===

Returns an enum indicating the boundary status of the browser.

This is achieved by moving the default cursor and checking the position, however the current default form values will not be altered. After checking for the boundary, the cursor is moved back to its former position. See [[Qt:Документация 4.3.2/q3databrowser#Boundary-enum | Q3DataBrowser::Boundary]].

See also [[Qt:Документация 4.3.2/q3databrowser#Boundary-enum | Boundary]].

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

Clears all the values in the form.

All the edit buffer field values are set to their 'zero state', e.g. 0 for numeric fields and "" for string fields. Then the widgets are updated using the property map. For example, a combobox that is property-mapped to integers would scroll to the first item. See the [[Qt:Документация 4.3.2/q3sqlpropertymap | Q3SqlPropertyMap]] constructor for the default mappings of widgets to properties.

===<div id="confirmCancel"></div>[[Qt:Документация 4.3.2/qsql-qt3#Confirm-enum | QSql::Confirm]] Q3DataBrowser::confirmCancel ( [[Qt:Документация 4.3.2/qsql-qt3#Op-enum | QSql::Op]] ''m'' )  <tt> [virtual protected]</tt>===

Protected virtual function which returns a confirmation for canceling an edit mode ''m''. Derived classes can reimplement this function and provide their own confirmation dialog. The default implementation uses a message box which prompts the user to confirm the edit action.

===<div id="confirmEdit"></div>[[Qt:Документация 4.3.2/qsql-qt3#Confirm-enum | QSql::Confirm]] Q3DataBrowser::confirmEdit ( [[Qt:Документация 4.3.2/qsql-qt3#Op-enum | QSql::Op]] ''m'' )  <tt> [virtual protected]</tt>===

Protected virtual function which returns a confirmation for an edit of mode ''m''. Derived classes can reimplement this function and provide their own confirmation dialog. The default implementation uses a message box which prompts the user to confirm the edit action.

===<div id="currentChanged"></div>void Q3DataBrowser::currentChanged ( const [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] * ''record'' )  <tt> [signal]</tt>===

This signal is emitted whenever the current cursor position changes. The ''record'' parameter points to the contents of the current cursor's record.

===<div id="currentEdited"></div>bool Q3DataBrowser::currentEdited ()  <tt> [virtual protected]</tt>===

Returns true if the form's edit buffer differs from the current cursor buffer; otherwise returns false.

===<div id="cursorChanged"></div>void Q3DataBrowser::cursorChanged ( [[Qt:Документация 4.3.2/q3sqlcursor#Mode-enum | Q3SqlCursor::Mode]] ''mode'' )  <tt> [signal]</tt>===

This signal is emitted whenever the cursor record was changed due to navigation. The ''mode'' parameter is the edit that just took place, e.g. Insert, Update or Delete. See [[Qt:Документация 4.3.2/q3sqlcursor#Mode-enum | Q3SqlCursor::Mode]].

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

Performs a delete operation on the data browser's cursor. If there is no default cursor or no default form, nothing happens.

Otherwise, the following happens:

The current form's record is deleted from the database, providing that the data browser is not in insert mode. If the data browser is actively inserting a record (see [[Qt:Документация 4.3.2/q3databrowser#insert | insert]]()), the insert action is canceled, and the browser navigates to the last valid record that was current. If there is an error, [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]() is called.

===<div id="deleteCurrent"></div>bool Q3DataBrowser::deleteCurrent ()  <tt> [virtual protected]</tt>===

Performs a delete on the default cursor using the values from the default form and updates the default form. If there is no default form or no default cursor, nothing happens. If the deletion was successful, the cursor is repositioned to the nearest record and true is returned. The nearest record is the next record if there is one otherwise the previous record if there is one. If an error occurred during the deletion from the database, [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]() is called and false is returned.

See also [[Qt:Документация 4.3.2/qwidget#cursor-prop | cursor]](), [[Qt:Документация 4.3.2/q3databrowser#form | form]](), and [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]().

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

Moves the default cursor to the first record and refreshes the default form to display this record. If there is no default form or no default cursor, nothing happens. If the data browser successfully navigated to the first record, the default cursor is primed for update and the [[Qt:Документация 4.3.2/q3databrowser#primeUpdate | primeUpdate]]() signal is emitted.

If the browser is already positioned on the first record nothing happens.

===<div id="firstRecordAvailable"></div>void Q3DataBrowser::firstRecordAvailable ( bool ''available'' )  <tt> [signal]</tt>===

This signal is emitted whenever the position of the cursor changes. The ''available'' parameter indicates whether or not the first record in the default cursor is available.

===<div id="form"></div>[[Qt:Документация 4.3.2/q3sqlform | Q3SqlForm]] * Q3DataBrowser::form ()===

Returns the data browser's default form or 0 if no form has been set.

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

===<div id="handleError"></div>void Q3DataBrowser::handleError ( const [[Qt:Документация 4.3.2/qsqlerror | QSqlError]] &amp; ''error'' )  <tt> [virtual protected]</tt>===

Virtual function which handles the error ''error''. The default implementation warns the user with a message box.

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

Performs an insert operation on the data browser's cursor. If there is no default cursor or no default form, nothing happens.

If auto-editing is on (see [[Qt:Документация 4.3.2/q3databrowser#autoEdit-prop | setAutoEdit]]()), the following happens:

*If the browser is already actively inserting a record, the current form's data is inserted into the database.
*If the browser is not inserting a record, but the current record was changed by the user, the record is updated in the database with the current form's data (i.e. with the changes).

If there is an error handling any of the above auto-edit actions, [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]() is called and no insert or update is performed.

If no error occurred, or auto-editing is not enabled, the data browser begins actively inserting a record into the database by performing the following actions:

*The default cursor is primed for insert using [[Qt:Документация 4.3.2/q3sqlcursor#primeInsert | Q3SqlCursor::primeInsert]]().
*The [[Qt:Документация 4.3.2/q3databrowser#primeInsert | primeInsert]]() signal is emitted.
*The form is updated with the values in the default cursor's. edit buffer so that the user can fill in the values to be inserted.

===<div id="insertCurrent"></div>bool Q3DataBrowser::insertCurrent ()  <tt> [virtual protected]</tt>===

Reads the fields from the default form into the default cursor and performs an insert on the default cursor. If there is no default form or no default cursor, nothing happens. If an error occurred during the insert into the database, [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]() is called and false is returned. If the insert was successful, the cursor is refreshed and relocated to the newly inserted record, the [[Qt:Документация 4.3.2/q3databrowser#cursorChanged | cursorChanged]]() signal is emitted, and true is returned.

See also [[Qt:Документация 4.3.2/q3databrowser#cursorChanged | cursorChanged]](), [[Qt:Документация 4.3.2/q3databrowser#sqlCursor | sqlCursor]](), [[Qt:Документация 4.3.2/q3databrowser#form | form]](), and [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]().

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

Moves the default cursor to the last record and refreshes the default form to display this record. If there is no default form or no default cursor, nothing happens. If the data browser successfully navigated to the last record, the default cursor is primed for update and the [[Qt:Документация 4.3.2/q3databrowser#primeUpdate | primeUpdate]]() signal is emitted.

If the browser is already positioned on the last record nothing happens.

===<div id="lastRecordAvailable"></div>void Q3DataBrowser::lastRecordAvailable ( bool ''available'' )  <tt> [signal]</tt>===

This signal is emitted whenever the position of the cursor changes. The ''available'' parameter indicates whether or not the last record in the default cursor is available.

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

Moves the default cursor to the next record and refreshes the default form to display this record. If there is no default form or no default cursor, nothing happens. If the data browser successfully navigated to the next record, the default cursor is primed for update and the [[Qt:Документация 4.3.2/q3databrowser#primeUpdate | primeUpdate]]() signal is emitted.

If the browser is positioned on the last record nothing happens.

===<div id="nextRecordAvailable"></div>void Q3DataBrowser::nextRecordAvailable ( bool ''available'' )  <tt> [signal]</tt>===

This signal is emitted whenever the position of the cursor changes. The ''available'' parameter indicates whether or not the next record in the default cursor is available.

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

Moves the default cursor to the previous record and refreshes the default form to display this record. If there is no default form or no default cursor, nothing happens. If the data browser successfully navigated to the previous record, the default cursor is primed for update and the [[Qt:Документация 4.3.2/q3databrowser#primeUpdate | primeUpdate]]() signal is emitted.

If the browser is positioned on the first record nothing happens.

===<div id="prevRecordAvailable"></div>void Q3DataBrowser::prevRecordAvailable ( bool ''available'' )  <tt> [signal]</tt>===

This signal is emitted whenever the position of the cursor changes. The ''available'' parameter indicates whether or not the previous record in the default cursor is available.

===<div id="primeDelete"></div>void Q3DataBrowser::primeDelete ( [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] * ''buf'' )  <tt> [signal]</tt>===

This signal is emitted when the data browser enters deletion mode. The ''buf'' parameter points to the record buffer being deleted. (Note that [[Qt:Документация 4.3.2/q3sqlcursor#primeDelete | Q3SqlCursor::primeDelete]]() is ''not'' called on the default cursor, as this would corrupt values in the form.) Connect to this signal in order to, for example, save a copy of the deleted record for auditing purposes.

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

===<div id="primeInsert"></div>void Q3DataBrowser::primeInsert ( [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] * ''buf'' )  <tt> [signal]</tt>===

This signal is emitted when the data browser enters insertion mode. The ''buf'' parameter points to the record buffer that is to be inserted. Connect to this signal to, for example, prime the record buffer with default data values, auto-numbered fields etc. (Note that [[Qt:Документация 4.3.2/q3sqlcursor#primeInsert | Q3SqlCursor::primeInsert]]() is ''not'' called on the default cursor, as this would corrupt values in the form.)

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

===<div id="primeUpdate"></div>void Q3DataBrowser::primeUpdate ( [[Qt:Документация 4.3.2/qsqlrecord | QSqlRecord]] * ''buf'' )  <tt> [signal]</tt>===

This signal is emitted when the data browser enters update mode. Note that during navigation ([[Qt:Документация 4.3.2/q3databrowser#first | first]](), [[Qt:Документация 4.3.2/q3databrowser#last | last]](), [[Qt:Документация 4.3.2/q3databrowser#next | next]](), [[Qt:Документация 4.3.2/q3databrowser#prev | prev]]()), each record that is shown in the default form is primed for update. The ''buf'' parameter points to the record buffer being updated. (Note that [[Qt:Документация 4.3.2/q3sqlcursor#primeUpdate | Q3SqlCursor::primeUpdate]]() is ''not'' called on the default cursor, as this would corrupt values in the form.) Connect to this signal in order to, for example, keep track of which records have been updated, perhaps for auditing purposes.

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

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

Reads the fields from the default cursor's edit buffer and displays them in the form. If there is no default cursor or no default form, nothing happens.

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

Refreshes the data browser's data using the default cursor. The browser's current filter and sort are applied if they have been set.

See also [[Qt:Документация 4.3.2/q3databrowser#filter-prop | setFilter]]() and [[Qt:Документация 4.3.2/q3databrowser#sort-prop | setSort]]().

===<div id="seek"></div>bool Q3DataBrowser::seek ( int ''i'', bool ''relative'' = false )  <tt> [virtual]</tt>===

Moves the default cursor to the record specified by index ''i'' and refreshes the default form to display that record. If there is no default form or no default cursor, nothing happens. If ''relative'' is true (the default is false), the cursor is moved relative to its current position. If the data browser successfully navigated to the desired record, the default cursor is primed for update and the [[Qt:Документация 4.3.2/q3databrowser#primeUpdate | primeUpdate]]() signal is emitted.

If the browser is already positioned on the desired record nothing happens. Returns false if there is no cursor. Otherwise returns true.

===<div id="setForm"></div>void Q3DataBrowser::setForm ( [[Qt:Документация 4.3.2/q3sqlform | Q3SqlForm]] * ''form'' )  <tt> [virtual]</tt>===

Sets the browser's default form to ''form''. The cursor and all navigation and data manipulation functions that the browser provides become available to the ''form''.

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

===<div id="setSqlCursor"></div>void Q3DataBrowser::setSqlCursor ( [[Qt:Документация 4.3.2/q3sqlcursor | Q3SqlCursor]] * ''cursor'', bool ''autoDelete'' = false )  <tt> [virtual]</tt>===

Sets the default cursor used by the data browser to ''cursor''. If ''autoDelete'' is true (the default is false), the data browser takes ownership of the ''cursor'' pointer, which will be deleted when the browser is destroyed, or when setSqlCursor() is called again. To activate the ''cursor'' use [[Qt:Документация 4.3.2/q3databrowser#refresh | refresh]](). The cursor's edit buffer is used in the default form to browse and edit records.

See also [[Qt:Документация 4.3.2/q3databrowser#sqlCursor | sqlCursor]](), [[Qt:Документация 4.3.2/q3databrowser#form | form]](), and [[Qt:Документация 4.3.2/q3databrowser#setForm | setForm]]().

===<div id="sqlCursor"></div>[[Qt:Документация 4.3.2/q3sqlcursor | Q3SqlCursor]] * Q3DataBrowser::sqlCursor () const===

Returns the default cursor used for navigation, or 0 if there is no default cursor.

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

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

Performs an update operation on the data browser's cursor.

If there is no default cursor or no default form, nothing happens. Otherwise, the following happens:

If the data browser is actively inserting a record (see [[Qt:Документация 4.3.2/q3databrowser#insert | insert]]()), that record is inserted into the database using [[Qt:Документация 4.3.2/q3databrowser#insertCurrent | insertCurrent]](). Otherwise, the database is updated with the current form's data using [[Qt:Документация 4.3.2/q3databrowser#updateCurrent | updateCurrent]](). If there is an error handling either action, [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]() is called.

===<div id="updateBoundary"></div>void Q3DataBrowser::updateBoundary ()  <tt> [slot]</tt>===

If [[Qt:Документация 4.3.2/q3databrowser#boundaryChecking-prop | boundaryChecking]]() is true, checks the boundary of the current default cursor and emits signals which indicate the position of the cursor.

===<div id="updateCurrent"></div>bool Q3DataBrowser::updateCurrent ()  <tt> [virtual protected]</tt>===

Reads the fields from the default form into the default cursor and performs an update on the default cursor. If there is no default form or no default cursor, nothing happens. If an error occurred during the update on the database, [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]() is called and false is returned. If the update was successful, the cursor is refreshed and relocated to the updated record, the [[Qt:Документация 4.3.2/q3databrowser#cursorChanged | cursorChanged]]() signal is emitted, and true is returned.

See also [[Qt:Документация 4.3.2/qwidget#cursor-prop | cursor]](), [[Qt:Документация 4.3.2/q3databrowser#form | form]](), and [[Qt:Документация 4.3.2/q3databrowser#handleError | handleError]]().

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

Writes the form's data to the default cursor's edit buffer. If there is no default cursor or no default form, nothing happens.


{{Qt4.3.2_footer}}