Q3DataBrowser Class Reference

 #include <Q3DataBrowser>

 QStringList list = myDataBrowser.sort();
 QStringList::Iterator it = list.begin();
 while(it != list.end()) {
     myProcessing(*it);
     ++it;
 }

Member Function Documentation

Q3DataBrowser::Q3DataBrowser ( QWidget * parent = 0, const char * name = 0, Qt::WindowFlags fl = 0 )

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

Q3DataBrowser::~Q3DataBrowser ()

Destroys the object and frees any allocated resources.

void Q3DataBrowser::beforeDelete ( QSqlRecord * buf ) [signal]

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.

void Q3DataBrowser::beforeInsert ( QSqlRecord * buf ) [signal]

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.

void Q3DataBrowser::beforeUpdate ( QSqlRecord * buf ) [signal]

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.

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 Q3DataBrowser::Boundary.

See also Boundary.

void Q3DataBrowser::clearValues () [virtual slot]

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 Q3SqlPropertyMap constructor for the default mappings of widgets to properties.

QSql::Confirm Q3DataBrowser::confirmCancel ( QSql::Op m ) [virtual protected]

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.

QSql::Confirm Q3DataBrowser::confirmEdit ( QSql::Op m ) [virtual protected]

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.

void Q3DataBrowser::currentChanged ( const QSqlRecord * record ) [signal]

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

bool Q3DataBrowser::currentEdited () [virtual protected]

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

void Q3DataBrowser::cursorChanged ( Q3SqlCursor::Mode mode ) [signal]

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 Q3SqlCursor::Mode.

void Q3DataBrowser::del () [virtual slot]

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 insert()), the insert action is canceled, and the browser navigates to the last valid record that was current. If there is an error, handleError() is called.

bool Q3DataBrowser::deleteCurrent () [virtual protected]

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, handleError() is called and false is returned.

See also cursor(), form(), and handleError().

void Q3DataBrowser::first () [virtual slot]

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 primeUpdate() signal is emitted.

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

void Q3DataBrowser::firstRecordAvailable ( bool available ) [signal]

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.

Q3SqlForm * Q3DataBrowser::form ()

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

See also setForm().

void Q3DataBrowser::handleError ( const QSqlError & error ) [virtual protected]

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

void Q3DataBrowser::insert () [virtual slot]

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 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, 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 Q3SqlCursor::primeInsert().
• The 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.

bool Q3DataBrowser::insertCurrent () [virtual protected]

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, handleError() is called and false is returned. If the insert was successful, the cursor is refreshed and relocated to the newly inserted record, the cursorChanged() signal is emitted, and true is returned.

See also cursorChanged(), sqlCursor(), form(), and handleError().

void Q3DataBrowser::last () [virtual slot]

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 primeUpdate() signal is emitted.

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

void Q3DataBrowser::lastRecordAvailable ( bool available ) [signal]

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.

void Q3DataBrowser::next () [virtual slot]

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 primeUpdate() signal is emitted.

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

void Q3DataBrowser::nextRecordAvailable ( bool available ) [signal]

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.

void Q3DataBrowser::prev () [virtual slot]

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 primeUpdate() signal is emitted.

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

void Q3DataBrowser::prevRecordAvailable ( bool available ) [signal]

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.

void Q3DataBrowser::primeDelete ( QSqlRecord * buf ) [signal]

This signal is emitted when the data browser enters deletion mode. The buf parameter points to the record buffer being deleted. (Note that 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 del().

void Q3DataBrowser::primeInsert ( QSqlRecord * buf ) [signal]

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 Q3SqlCursor::primeInsert() is not called on the default cursor, as this would corrupt values in the form.)

See also insert().

void Q3DataBrowser::primeUpdate ( QSqlRecord * buf ) [signal]

This signal is emitted when the data browser enters update mode. Note that during navigation (first(), last(), next(), 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 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 update().

void Q3DataBrowser::readFields () [virtual slot]

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.

void Q3DataBrowser::refresh () [virtual slot]

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 setFilter() and setSort().

bool Q3DataBrowser::seek ( int i, bool relative = false ) [virtual]

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 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.

void Q3DataBrowser::setForm ( Q3SqlForm * form ) [virtual]

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 form().

void Q3DataBrowser::setSqlCursor ( Q3SqlCursor * cursor, bool autoDelete = false ) [virtual]

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 refresh(). The cursor's edit buffer is used in the default form to browse and edit records.

See also sqlCursor(), form(), and setForm().

Q3SqlCursor * Q3DataBrowser::sqlCursor () const

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

See also setSqlCursor().

void Q3DataBrowser::update () [virtual slot]

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 insert()), that record is inserted into the database using insertCurrent(). Otherwise, the database is updated with the current form's data using updateCurrent(). If there is an error handling either action, handleError() is called.

void Q3DataBrowser::updateBoundary () [slot]

If boundaryChecking() is true, checks the boundary of the current default cursor and emits signals which indicate the position of the cursor.

bool Q3DataBrowser::updateCurrent () [virtual protected]

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, handleError() is called and false is returned. If the update was successful, the cursor is refreshed and relocated to the updated record, the cursorChanged() signal is emitted, and true is returned.

See also cursor(), form(), and handleError().

void Q3DataBrowser::writeFields () [virtual slot]

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