QSqlError Class

The QSqlError class provides SQL database error information. More...

Header: #include <QSqlError>
qmake: QT += sql

Public Types

enum ErrorType { NoError, ConnectionError, StatementError, TransactionError, UnknownError }

Public Functions

QSqlError(const QString & driverText = QString(), const QString & databaseText = QString(), ErrorType type = NoError, int number = -1)
QSqlError(const QSqlError & other)
~QSqlError()
QString databaseText() const
QString driverText() const
bool isValid() const
int number() const
QString text() const
ErrorType type() const
bool operator!=(const QSqlError & other) const
QSqlError & operator=(const QSqlError & other)
bool operator==(const QSqlError & other) const

Detailed Description

The QSqlError class provides SQL database error information.

A QSqlError object can provide database-specific error data, including the driverText() and databaseText() messages (or both concatenated together as text()), and the error number() and type().

See also QSqlDatabase::lastError() and QSqlQuery::lastError().

Member Type Documentation

enum QSqlError::ErrorType

This enum type describes the context in which the error occurred, e.g., a connection error, a statement error, etc.

ConstantValueDescription
QSqlError::NoError0No error occurred.
QSqlError::ConnectionError1Connection error.
QSqlError::StatementError2SQL statement syntax error.
QSqlError::TransactionError3Transaction failed error.
QSqlError::UnknownError4Unknown error.

Member Function Documentation

QSqlError::QSqlError(const QString & driverText = QString(), const QString & databaseText = QString(), ErrorType type = NoError, int number = -1)

Constructs an error containing the driver error text driverText, the database-specific error text databaseText, the type type and the optional error number number.

QSqlError::QSqlError(const QSqlError & other)

Creates a copy of other.

QSqlError::~QSqlError()

Destroys the object and frees any allocated resources.

QString QSqlError::databaseText() const

Returns the text of the error as reported by the database. This may contain database-specific descriptions; it may be empty.

See also setDatabaseText(), driverText(), and text().

QString QSqlError::driverText() const

Returns the text of the error as reported by the driver. This may contain database-specific descriptions. It may also be empty.

See also setDriverText(), databaseText(), and text().

bool QSqlError::isValid() const

Returns true if an error is set, otherwise false.

Example:

QSqlQueryModel model;
model.setQuery("select * from myTable");
if (model.lastError().isValid())
    qDebug() << model.lastError();

See also type().

int QSqlError::number() const

Returns the database-specific error number, or -1 if it cannot be determined.

See also setNumber().

QString QSqlError::text() const

This is a convenience function that returns databaseText() and driverText() concatenated into a single string.

See also driverText() and databaseText().

ErrorType QSqlError::type() const

Returns the error type, or -1 if the type cannot be determined.

See also setType().

bool QSqlError::operator!=(const QSqlError & other) const

Compare the other error's values to this error and returns true if it is not equal.

QSqlError & QSqlError::operator=(const QSqlError & other)

Assigns the other error's values to this error.

bool QSqlError::operator==(const QSqlError & other) const

Compare the other error's values to this error and returns true, if it equal.