From d796c9dd933ab96ec83b9a634feedd5d32e1ba3f Mon Sep 17 00:00:00 2001 From: Timothy Pearson Date: Tue, 8 Nov 2011 12:31:36 -0600 Subject: Test conversion to TQt3 from Qt3 8c6fc1f8e35fd264dd01c582ca5e7549b32ab731 --- doc/html/qdatatable.html | 809 +++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 809 insertions(+) create mode 100644 doc/html/qdatatable.html (limited to 'doc/html/qdatatable.html') diff --git a/doc/html/qdatatable.html b/doc/html/qdatatable.html new file mode 100644 index 000000000..f9ad0d09a --- /dev/null +++ b/doc/html/qdatatable.html @@ -0,0 +1,809 @@ + + + + + +TQDataTable Class + + + + + + + +
+ +Home + | +All Classes + | +Main Classes + | +Annotated + | +Grouped Classes + | +Functions +

TQDataTable Class Reference
[sql module]

+ +

The TQDataTable class provides a flexible SQL table widget that supports browsing and editing. +More... +

#include <qdatatable.h> +

Inherits TQTable. +

List of all member functions. +

Public Members

+ +

Public Slots

+ +

Signals

+ +

Properties

+ +

Protected Members

+ +

Detailed Description

+ + +The TQDataTable class provides a flexible SQL table widget that supports browsing and editing. +

+ + +

TQDataTable supports various functions for presenting and editing +SQL data from a TQSqlCursor in a table. +

If you want a to present your data in a form use TQDataBrowser, or +for read-only forms, TQDataView. +

When displaying data, TQDataTable only retrieves data for visible +rows. If the driver supports the 'query size' property the +TQDataTable will have the correct number of rows and the vertical +scrollbar will accurately reflect the number of rows displayed in +proportion to the number of rows in the dataset. If the driver +does not support the 'query size' property, rows are dynamically +fetched from the database on an as-needed basis with the scrollbar +becoming more accurate as the user scrolls down through the +records. This allows extremely large queries to be displayed as +tquickly as possible, with minimum memory usage. +

TQDataTable inherits TQTable's API and extends it with functions to +sort and filter the data and sort columns. See setSqlCursor(), +setFilter(), setSort(), setSorting(), sortColumn() and refresh(). +

When displaying editable cursors, cell editing will be enabled. +(For more information on editable cursors, see TQSqlCursor). +TQDataTable can be used to modify existing data and to add new +records. When a user makes changes to a field in the table, the +cursor's edit buffer is used. The table will not send changes in +the edit buffer to the database until the user moves to a +different record in the grid or presses Enter. Cell editing is +initiated by pressing F2 (or right clicking and then clicking the +appropriate popup menu item) and canceled by pressing Esc. If +there is a problem updating or adding data, errors are handled +automatically (see handleError() to change this behavior). Note +that if autoEdit() is FALSE navigating to another record will +cancel the insert or update. +

The user can be asked to confirm all edits with setConfirmEdits(). +For more precise control use setConfirmInsert(), +setConfirmUpdate(), setConfirmDelete() and setConfirmCancels(). +Use setAutoEdit() to control the behaviour of the table when the +user edits a record and then navigates. (Note that setAutoDelete() +is unrelated; it is used to set whether the TQSqlCursor is deleted +when the table is deleted.) +

Since the data table can perform edits, it must be able to +uniquely identify every record so that edits are correctly +applied. Because of this the underlying cursor must have a valid +primary index to ensure that a unique record is inserted, updated +or deleted within the database otherwise the database may be +changed to an inconsistent state. +

TQDataTable creates editors using the default TQSqlEditorFactory. +Different editor factories can be used by calling +installEditorFactory(). A property map is used to map between the +cell's value and the editor. You can use your own property map +with installPropertyMap(). +

The contents of a cell is available as a TQString with text() or as +a TQVariant with value(). The current record is returned by +currentRecord(). Use the find() function to search for a string in +the table. +

Editing actions can be applied programatically. For example, the +insertCurrent() function reads the fields from the current record +into the cursor and performs the insert. The updateCurrent() and +deleteCurrent() functions perform similarly to update and delete +the current record respectively. +

Columns in the table can be created automatically based on the +cursor (see setSqlCursor()). Columns can be manipulated manually +using addColumn(), removeColumn() and setColumn(). +

The table automatically copies many of the properties of the +cursor to format the display of data within cells (alignment, +visibility, etc.). The cursor can be changed with setSqlCursor(). +The filter (see setFilter()) and sort defined within the table are +used instead of the filter and sort set on the cursor. For sorting +options see setSort(), sortColumn(), sortAscending() and +sortDescending(). Note that sorting operations will not behave as +expected if you are using a TQSqlSelectCursor because it uses +user-defined SQL queries to obtain data. +

The text used to represent NULL, TRUE and FALSE values can be +changed with setNullText(), setTrueText() and setFalseText() +respectively. You can change the appearance of cells by +reimplementing paintField(). +

Whenever a new row is selected in the table the currentChanged() +signal is emitted. The primeInsert() signal is emitted when an +insert is initiated. The primeUpdate() and primeDelete() signals +are emitted when update and deletion are initiated respectively. +Just before the database is updated a signal is emitted; +beforeInsert(), beforeUpdate() or beforeDelete() as appropriate. +

See also Database Classes. + +

Member Type Documentation

+

TQDataTable::Refresh

+ +

This enum describes the refresh options. +

+

Member Function Documentation

+

TQDataTable::TQDataTable ( TQWidget * parent = 0, const char * name = 0 ) +

+Constructs a data table which is a child of parent, called +name name. + +

TQDataTable::TQDataTable ( TQSqlCursor * cursor, bool autoPopulate = FALSE, TQWidget * parent = 0, const char * name = 0 ) +

+Constructs a data table which is a child of parent, called name +name using the cursor cursor. +

If autoPopulate is TRUE (the default is FALSE), columns are +automatically created based upon the fields in the cursor +record. Note that autoPopulate only governs the creation of +columns; to load the cursor's data into the table use refresh(). +

If the cursor is read-only, the table also becomes read-only. +In addition, the table adopts the cursor's driver's definition for +representing NULL values as strings. + +

TQDataTable::~TQDataTable () +

+Destroys the object and frees any allocated resources. + +

void TQDataTable::addColumn ( const TQString & fieldName, const TQString & label = TQString::null, int width = -1, const TQIconSet & iconset = TQIconSet ( ) ) [virtual] +

+Adds the next column to be displayed using the field fieldName, +column label label, width width and iconset iconset. +

If label is specified, it is used as the column's header label, +otherwise the field's display label is used when setSqlCursor() is +called. The iconset is used to set the icon used by the column +header; by default there is no icon. +

See also setSqlCursor() and refresh(). + +

Examples: sql/overview/subclass1/main.cpp, sql/overview/subclass3/main.cpp, sql/overview/table2/main.cpp, and sql/sqltable/main.cpp. +

void TQDataTable::adjustColumn ( int col ) [virtual slot] +

+Resizes column col so that the column width is wide enough to +display the widest item the column contains (including the column +label). If the table's TQSqlCursor is not currently active, the +cursor will be refreshed before the column width is calculated. Be +aware that this function may be slow on tables that contain large +result sets. + +

Reimplemented from TQTable. +

bool TQDataTable::autoDelete () const +

+Returns TRUE if the table will automatically delete the cursor +specified by setSqlCursor(); otherwise returns FALSE. + +

bool TQDataTable::autoEdit () const +

Returns TRUE if the data table automatically applies edits; otherwise returns FALSE. +See the "autoEdit" property for details. +

void TQDataTable::beforeDelete ( TQSqlRecord * buf ) [signal] +

+ +

This signal is emitted just before the currently selected record +is deleted from the database. The buf parameter points to the +edit buffer being deleted. Connect to this signal to, for example, +copy some of the fields for later use. + +

void TQDataTable::beforeInsert ( TQSqlRecord * 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. Connect to this signal to, for +example, populate a key field with a unique sequence number. + +

void TQDataTable::beforeUpdate ( TQSqlRecord * 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. Connect to this signal when you want to +transform the user's data behind-the-scenes. + +

bool TQDataTable::beginInsert () [virtual protected] +

+Protected virtual function called when editing is about to begin +on a new record. If the table is read-only, or if there's no +cursor or the cursor does not allow inserts, nothing happens. +

Editing takes place using the cursor's edit buffer(see +TQSqlCursor::editBuffer()). +

When editing begins, a new row is created in the table marked with +an asterisk '*' in the row's vertical header column, i.e. at the +left of the row. + +

TQWidget * TQDataTable::beginUpdate ( int row, int col, bool replace ) [virtual protected] +

+Protected virtual function called when editing is about to begin +on an existing row. If the table is read-only, or if there's no +cursor, nothing happens. +

Editing takes place using the cursor's edit buffer (see +TQSqlCursor::editBuffer()). +

row and col refer to the row and column in the TQDataTable. +

(replace is provided for reimplementors and reflects the API of +TQTable::beginEdit().) + +

TQSql::Confirm TQDataTable::confirmCancel ( TQSql::Op m ) [virtual protected] +

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

bool TQDataTable::confirmCancels () const +

Returns TRUE if the data table confirms cancel operations; otherwise returns FALSE. +See the "confirmCancels" property for details. +

bool TQDataTable::confirmDelete () const +

Returns TRUE if the data table confirms delete operations; otherwise returns FALSE. +See the "confirmDelete" property for details. +

TQSql::Confirm TQDataTable::confirmEdit ( TQSql::Op m ) [virtual protected] +

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

bool TQDataTable::confirmEdits () const +

Returns TRUE if the data table confirms edit operations; otherwise returns FALSE. +See the "confirmEdits" property for details. +

bool TQDataTable::confirmInsert () const +

Returns TRUE if the data table confirms insert operations; otherwise returns FALSE. +See the "confirmInsert" property for details. +

bool TQDataTable::confirmUpdate () const +

Returns TRUE if the data table confirms update operations; otherwise returns FALSE. +See the "confirmUpdate" property for details. +

void TQDataTable::currentChanged ( TQSqlRecord * record ) [signal] +

+ +

This signal is emitted whenever a new row is selected in the +table. The record parameter points to the contents of the newly +selected record. + +

TQSqlRecord * TQDataTable::currentRecord () const +

+Returns the currently selected record, or 0 if there is no current +selection. The table owns the pointer, so do not delete it or +otherwise modify it or the cursor it points to. + +

void TQDataTable::cursorChanged ( TQSql::Op mode ) [signal] +

+ +

This signal is emitted whenever the cursor record was changed due +to an edit. The mode parameter is the type of edit that just +took place. + +

DateFormat TQDataTable::dateFormat () const +

Returns the format used for displaying date/time values. +See the "dateFormat" property for details. +

bool TQDataTable::deleteCurrent () [virtual protected] +

+For an editable table, issues a delete on the current cursor's +primary index using the values of the currently selected row. If +there is no current cursor or there is no current selection, +nothing happens. If confirmEdits() or confirmDelete() is TRUE, +confirmEdit() is called to confirm the delete. Returns TRUE if the +delete succeeded; otherwise FALSE. +

The underlying cursor must have a valid primary index to ensure +that a unique record is deleted within the database otherwise the +database may be changed to an inconsistent state. + +

TQString TQDataTable::falseText () const +

Returns the text used to represent false values. +See the "falseText" property for details. +

int TQDataTable::fieldAlignment ( const TQSqlField * field ) [virtual protected] +

+Returns the alignment for field. + +

TQString TQDataTable::filter () const +

Returns the data filter for the data table. +See the "filter" property for details. +

void TQDataTable::find ( const TQString & str, bool caseSensitive, bool backwards ) [virtual slot] +

+Searches the current cursor for a cell containing the string str starting at the current cell and working forwards (or +backwards if backwards is TRUE). If the string is found, the +cell containing the string is set as the current cell. If caseSensitive is FALSE the case of str will be ignored. +

The search will wrap, i.e. if the first (or if backwards is TRUE, +last) cell is reached without finding str the search will +continue until it reaches the starting cell. If str is not +found the search will fail and the current cell will remain +unchanged. + +

void TQDataTable::handleError ( const TQSqlError & e ) [virtual protected] +

+Protected virtual function which is called when an error e has +occurred on the current cursor(). The default implementation +displays a warning message to the user with information about the +error. + +

int TQDataTable::indexOf ( uint i ) const [protected] +

+Returns the index of the field within the current SQL query that +is displayed in column i. + +

bool TQDataTable::insertCurrent () [virtual protected] +

+For an editable table, issues an insert on the current cursor +using the values in the cursor's edit buffer. If there is no +current cursor or there is no current "insert" row, nothing +happens. If confirmEdits() or confirmInsert() is TRUE, +confirmEdit() is called to confirm the insert. Returns TRUE if the +insert succeeded; otherwise returns FALSE. +

The underlying cursor must have a valid primary index to ensure +that a unique record is inserted within the database otherwise the +database may be changed to an inconsistent state. + +

void TQDataTable::installEditorFactory ( TQSqlEditorFactory * f ) +

+Installs a new SQL editor factory f. This enables the user to +create and instantiate their own editors for use in cell editing. +Note that TQDataTable takes ownership of this pointer, and will +delete it when it is no longer needed or when +installEditorFactory() is called again. +

See also TQSqlEditorFactory. + +

void TQDataTable::installPropertyMap ( TQSqlPropertyMap * m ) +

+Installs a new property map m. This enables the user to create +and instantiate their own property maps for use in cell editing. +Note that TQDataTable takes ownership of this pointer, and will +delete it when it is no longer needed or when installPropertMap() +is called again. +

See also TQSqlPropertyMap. + +

TQString TQDataTable::nullText () const +

Returns the text used to represent NULL values. +See the "nullText" property for details. +

int TQDataTable::numCols () const [virtual] +

Returns the number of columns in the table. +See the "numCols" property for details. +

Reimplemented from TQTable. +

int TQDataTable::numRows () const [virtual] +

Returns the number of rows in the table. +See the "numRows" property for details. +

Reimplemented from TQTable. +

void TQDataTable::paintField ( TQPainter * p, const TQSqlField * field, const TQRect & cr, bool selected ) [virtual protected] +

+Paints the field on the painter p. The painter has already +been translated to the appropriate cell's origin where the field is to be rendered. cr describes the cell coordinates in +the content coordinate system. The selected parameter is +ignored. +

If you want to draw custom field content you must reimplement +paintField() to do the custom drawing. The default implementation +renders the field value as text. If the field is NULL, +nullText() is displayed in the cell. If the field is Boolean, +trueText() or falseText() is displayed as appropriate. + +

Example: sql/overview/table4/main.cpp. +

void TQDataTable::primeDelete ( TQSqlRecord * buf ) [signal] +

+ +

This signal is emitted after the cursor is primed for delete by +the table, when a delete action is beginning on the table. The buf parameter points to the edit buffer being deleted. Connect to +this signal in order to, for example, record auditing information +on deletions. + +

void TQDataTable::primeInsert ( TQSqlRecord * buf ) [signal] +

+ +

This signal is emitted after the cursor is primed for insert by +the table, when an insert action is beginning on the table. The buf parameter points to the edit buffer being inserted. Connect to +this signal in order to, for example, prime the record buffer with +default data values. + +

void TQDataTable::primeUpdate ( TQSqlRecord * buf ) [signal] +

+ +

This signal is emitted after the cursor is primed for update by +the table, when an update action is beginning on the table. The buf parameter points to the edit buffer being updated. Connect to +this signal in order to, for example, provide some visual feedback +that the user is in 'edit mode'. + +

void TQDataTable::refresh () [virtual slot] +

+Refreshes the table. The cursor is refreshed using the current +filter, the current sort, and the currently defined columns. +Equivalent to calling refresh( TQDataTable::RefreshData ). + +

Examples: sql/overview/subclass1/main.cpp, sql/overview/table1/main.cpp, sql/overview/table2/main.cpp, and sql/sqltable/main.cpp. +

void TQDataTable::refresh ( Refresh mode ) +

+This is an overloaded member function, provided for convenience. It behaves essentially like the above function. +

Refreshes the table. If there is no currently defined cursor (see +setSqlCursor()), nothing happens. The mode parameter determines +which type of refresh will take place. +

See also Refresh, setSqlCursor(), and addColumn(). + +

void TQDataTable::removeColumn ( uint col ) [virtual] +

+Removes column col from the list of columns to be displayed. If +col does not exist, nothing happens. +

See also TQSqlField. + +

void TQDataTable::reset () [protected] +

+Resets the table so that it displays no data. +

See also setSqlCursor(). + +

void TQDataTable::setAutoDelete ( bool enable ) [virtual] +

+Sets the cursor auto-delete flag to enable. If enable is +TRUE, the table will automatically delete the cursor specified by +setSqlCursor(). If enable is FALSE (the default), the cursor +will not be deleted. + +

void TQDataTable::setAutoEdit ( bool autoEdit ) [virtual] +

Sets whether the data table automatically applies edits to autoEdit. +See the "autoEdit" property for details. +

void TQDataTable::setColumn ( uint col, const TQString & fieldName, const TQString & label = TQString::null, int width = -1, const TQIconSet & iconset = TQIconSet ( ) ) [virtual] +

+Sets the col column to display using the field fieldName, +column label label, width width and iconset iconset. +

If label is specified, it is used as the column's header label, +otherwise the field's display label is used when setSqlCursor() is +called. The iconset is used to set the icon used by the column +header; by default there is no icon. +

See also setSqlCursor() and refresh(). + +

void TQDataTable::setColumnWidth ( int col, int w ) [virtual slot] +

+Sets the column col to the width w. Note that unlike TQTable +the TQDataTable is not immediately redrawn, you must call +refresh(TQDataTable::RefreshColumns) +yourself. +

See also refresh(). + +

Reimplemented from TQTable. +

void TQDataTable::setConfirmCancels ( bool confirm ) [virtual] +

Sets whether the data table confirms cancel operations to confirm. +See the "confirmCancels" property for details. +

void TQDataTable::setConfirmDelete ( bool confirm ) [virtual] +

Sets whether the data table confirms delete operations to confirm. +See the "confirmDelete" property for details. +

void TQDataTable::setConfirmEdits ( bool confirm ) [virtual] +

Sets whether the data table confirms edit operations to confirm. +See the "confirmEdits" property for details. +

void TQDataTable::setConfirmInsert ( bool confirm ) [virtual] +

Sets whether the data table confirms insert operations to confirm. +See the "confirmInsert" property for details. +

void TQDataTable::setConfirmUpdate ( bool confirm ) [virtual] +

Sets whether the data table confirms update operations to confirm. +See the "confirmUpdate" property for details. +

void TQDataTable::setDateFormat ( const DateFormat f ) [virtual] +

Sets the format used for displaying date/time values to f. +See the "dateFormat" property for details. +

void TQDataTable::setFalseText ( const TQString & falseText ) [virtual] +

Sets the text used to represent false values to falseText. +See the "falseText" property for details. +

void TQDataTable::setFilter ( const TQString & filter ) [virtual] +

Sets the data filter for the data table to filter. +See the "filter" property for details. +

void TQDataTable::setNullText ( const TQString & nullText ) [virtual] +

Sets the text used to represent NULL values to nullText. +See the "nullText" property for details. +

void TQDataTable::setSize ( TQSqlCursor * sql ) [protected] +

+If the cursor's sql driver supports query sizes, the number of +rows in the table is set to the size of the query. Otherwise, the +table dynamically resizes itself as it is scrolled. If sql is +not active, it is made active by issuing a select() on the cursor +using the sql cursor's current filter and current sort. + +

void TQDataTable::setSort ( const TQStringList & sort ) [virtual] +

Sets the data table's sort to sort. +See the "sort" property for details. +

void TQDataTable::setSort ( const TQSqlIndex & sort ) [virtual] +

+This is an overloaded member function, provided for convenience. It behaves essentially like the above function. +

Sets the sort to be applied to the displayed data to sort. If +there is no current cursor, nothing happens. A TQSqlIndex contains +field names and their ordering (ASC or DESC); these are used to +compose the ORDER BY clause. +

See also sort. + +

void TQDataTable::setSqlCursor ( TQSqlCursor * cursor = 0, bool autoPopulate = FALSE, bool autoDelete = FALSE ) [virtual] +

+Sets cursor as the data source for the table. To force the +display of the data from cursor, use refresh(). If autoPopulate is TRUE, columns are automatically created based upon +the fields in the cursor record. If autoDelete is TRUE (the +default is FALSE), the table will take ownership of the cursor +and delete it when appropriate. If the cursor is read-only, the +table becomes read-only. The table adopts the cursor's driver's +definition for representing NULL values as strings. +

See also refresh(), readOnly, setAutoDelete(), and TQSqlDriver::nullText(). + +

void TQDataTable::setTrueText ( const TQString & trueText ) [virtual] +

Sets the text used to represent true values to trueText. +See the "trueText" property for details. +

TQStringList TQDataTable::sort () const +

Returns the data table's sort. +See the "sort" property for details. +

void TQDataTable::sortAscending ( int col ) [virtual slot] +

+Sorts column col in ascending order. +

See also sorting. + +

void TQDataTable::sortColumn ( int col, bool ascending = TRUE, bool wholeRows = FALSE ) [virtual] +

+Sorts column col in ascending order if ascending is TRUE +(the default); otherwise sorts in descending order. +

The wholeRows parameter is ignored; TQDataTable always sorts +whole rows by the specified column. + +

Reimplemented from TQTable. +

void TQDataTable::sortDescending ( int col ) [virtual slot] +

+Sorts column col in descending order. +

See also sorting. + +

TQSqlCursor * TQDataTable::sqlCursor () const +

+Returns the cursor used by the data table. + +

TQString TQDataTable::text ( int row, int col ) const [virtual] +

+Returns the text in cell row, col, or an empty string if the +cell is empty. If the cell's value is NULL then nullText() will be +returned. If the cell does not exist then TQString::null is +returned. + +

Reimplemented from TQTable. +

TQString TQDataTable::trueText () const +

Returns the text used to represent true values. +See the "trueText" property for details. +

bool TQDataTable::updateCurrent () [virtual protected] +

+For an editable table, issues an update using the cursor's edit +buffer. If there is no current cursor or there is no current +selection, nothing happens. If confirmEdits() or confirmUpdate() +is TRUE, confirmEdit() is called to confirm the update. Returns +TRUE if the update succeeded; otherwise returns FALSE. +

The underlying cursor must have a valid primary index to ensure +that a unique record is updated within the database otherwise the +database may be changed to an inconsistent state. + +

TQVariant TQDataTable::value ( int row, int col ) const +

+Returns the value in cell row, col, or an invalid value if +the cell does not exist or has no value. + +

Property Documentation

+

bool autoEdit

+

This property holds whether the data table automatically applies edits. +

The default value for this property is TRUE. When the user begins +an insert or update in the table there are two possible outcomes +when they navigate to another record: +

    +
  1. the insert or update is is performed -- this occurs if autoEdit is TRUE +
  2. the insert or update is abandoned -- this occurs if autoEdit is FALSE +
+ +

Set this property's value with setAutoEdit() and get this property's value with autoEdit(). +

bool confirmCancels

+

This property holds whether the data table confirms cancel operations. +

If the confirmCancel property is TRUE, all cancels must be +confirmed by the user through a message box (this behavior can be +changed by overriding the confirmCancel() function), otherwise all +cancels occur immediately. The default is FALSE. +

See also confirmEdits and confirmCancel(). + +

Set this property's value with setConfirmCancels() and get this property's value with confirmCancels(). +

bool confirmDelete

+

This property holds whether the data table confirms delete operations. +

If the confirmDelete property is TRUE, all deletions must be +confirmed by the user through a message box (this behaviour can be +changed by overriding the confirmEdit() function), otherwise all +delete operations occur immediately. +

See also confirmCancels, confirmEdits, confirmUpdate, and confirmInsert. + +

Set this property's value with setConfirmDelete() and get this property's value with confirmDelete(). +

bool confirmEdits

+

This property holds whether the data table confirms edit operations. +

If the confirmEdits property is TRUE, the data table confirms all +edit operations (inserts, updates and deletes). Finer control of +edit confirmation can be achieved using confirmCancels, confirmInsert, confirmUpdate and confirmDelete. +

See also confirmCancels, confirmInsert, confirmUpdate, and confirmDelete. + +

Set this property's value with setConfirmEdits() and get this property's value with confirmEdits(). +

bool confirmInsert

+

This property holds whether the data table confirms insert operations. +

If the confirmInsert property is TRUE, all insertions must be +confirmed by the user through a message box (this behaviour can be +changed by overriding the confirmEdit() function), otherwise all +insert operations occur immediately. +

See also confirmCancels, confirmEdits, confirmUpdate, and confirmDelete. + +

Set this property's value with setConfirmInsert() and get this property's value with confirmInsert(). +

bool confirmUpdate

+

This property holds whether the data table confirms update operations. +

If the confirmUpdate property is TRUE, all updates must be +confirmed by the user through a message box (this behaviour can be +changed by overriding the confirmEdit() function), otherwise all +update operations occur immediately. +

See also confirmCancels, confirmEdits, confirmInsert, and confirmDelete. + +

Set this property's value with setConfirmUpdate() and get this property's value with confirmUpdate(). +

DateFormat dateFormat

+

This property holds the format used for displaying date/time values. +

The dateFormat property is used for displaying date/time values in +the table. The default value is TQt::LocalDate. + +

Set this property's value with setDateFormat() and get this property's value with dateFormat(). +

TQString falseText

+

This property holds the text used to represent false values. +

The falseText property will be used to represent NULL values in +the table. The default value is "False". + +

Set this property's value with setFalseText() and get this property's value with falseText(). +

TQString filter

+

This property holds the data filter for the data table. +

The filter applies to the data shown in the table. To view data +with a new filter, use refresh(). A filter string is an SQL WHERE +clause without the WHERE keyword. +

There is no default filter. +

See also sort. + +

+

Set this property's value with setFilter() and get this property's value with filter(). +

TQString nullText

+

This property holds the text used to represent NULL values. +

The nullText property will be used to represent NULL values in the +table. The default value is provided by the cursor's driver. + +

Set this property's value with setNullText() and get this property's value with nullText(). +

int numCols

+

This property holds the number of columns in the table. +

+

Get this property's value with numCols(). +

int numRows

+

This property holds the number of rows in the table. +

+

Get this property's value with numRows(). +

TQStringList sort

+

This property holds the data table's sort. +

The table's sort affects the order in which data records are +displayed in the table. To apply a sort, use refresh(). +

When examining the sort property, a string list is returned with +each item having the form 'fieldname order' (e.g., 'id ASC', +'surname DESC'). +

There is no default sort. +

Note that if you want to iterate over the sort list, you should +iterate over a copy, e.g. +

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

See also filter and refresh(). + +

Set this property's value with setSort() and get this property's value with sort(). +

TQString trueText

+

This property holds the text used to represent true values. +

The trueText property will be used to represent NULL values in the +table. The default value is "True". + +

Set this property's value with setTrueText() and get this property's value with trueText(). + +

+This file is part of the TQt toolkit. +Copyright © 1995-2007 +Trolltech. All Rights Reserved.

+ +
Copyright © 2007 +TrolltechTrademarks +
TQt 3.3.8
+
+ -- cgit v1.2.1