QSqlError¶

PyQt5.QtSql.QSqlError

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 nativeErrorCode() and type().

Enums¶

ErrorType

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

Member	Value	Description
ConnectionError	1	Connection error.
NoError	0	No error occurred.
StatementError	2	SQL statement syntax error.
TransactionError	3	Transaction failed error.
UnknownError	4	Unknown error.

Methods¶

__init__(QSqlError): Creates a copy of other.

__init__(driverText: str = '', databaseText: str = '', type: ErrorType = NoError, errorCode: str = '')

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

Note: DB2: It is possible for DB2 to report more than one error code. When this happens, ; is used as separator between the error codes.

__init__(str, str, ErrorType, int): TODO

databaseText() → str: Returns the text of the error as reported by the database. This may contain database-specific descriptions; it may be empty.

See also

text(), driverText().

driverText() → str: TODO

__eq__(QSqlError) → bool: TODO

isValid() → bool

Returns true if an error is set, otherwise false.

Example:

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