|  | Home · Overviews · Examples

# QSqlRecord Class Reference
[com.trolltech.qt.sql module]

The `QSqlRecord` class encapsulates a database record. More...

Inherited by `QSqlIndex`.

## Detailed Description

The `QSqlRecord` class encapsulates a database record.

The `QSqlRecord` class encapsulates the functionality and characteristics of a database record (usually a row in a table or view within the database). `QSqlRecord` supports adding and removing fields as well as setting and retrieving field values.

The values of a record's fields' can be set by name or position with `setValue`; if you want to set a field to null use `setNull`. To find the position of a field by name use `indexOf`, and to find the name of a field at a particular position use `fieldName`. Use `field` to retrieve a `QSqlField` object for a given field. Use `contains` to see if the record contains a particular field name.

When queries are generated to be executed on the database only those fields for which `isGenerated` is true are included in the generated SQL.

A record can have fields added with `append` or `insert`, replaced with `replace`, and removed with `remove`. All the fields can be removed with `clear`. The number of fields is given by `count`; all their values can be cleared (to null) using `clearValues`.

See also `QSqlField` and `QSqlQuery::record`.