QSqlError#

The QSqlError class provides SQL database error information. More…

Synopsis#

Functions#

def databaseText ()
def driverText ()
def isValid ()
def nativeErrorCode ()
def __ne__ (other)
def __eq__ (other)
def swap (other)
def text ()
def type ()

Note

This documentation may contain snippets that were automatically translated from C++ to Python. We always welcome contributions to the snippet translation. If you see an issue with the translation, you can also let us know by creating a ticket on https:/bugreports.qt.io/projects/PYSIDE

Detailed Description#

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

See also

lastError() lastError()

class PySide6.QtSql.QSqlError(other)#

PySide6.QtSql.QSqlError([driverText=””[, databaseText=””[, type=QSqlError.ErrorType.NoError[, errorCode=””]]]])

Parameters:

databaseText – str
other – PySide6.QtSql.QSqlError
type – ErrorType
driverText – str
errorCode – str

Creates a copy of other.

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.

PySide6.QtSql.QSqlError.ErrorType#

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

Constant

Description

QSqlError.NoError

No error occurred.

QSqlError.ConnectionError

Connection error.

QSqlError.StatementError

SQL statement syntax error.

QSqlError.TransactionError

Transaction failed error.

QSqlError.UnknownError

Unknown error.

Constant	Description
QSqlError.NoError	No error occurred.
QSqlError.ConnectionError	Connection error.
QSqlError.StatementError	SQL statement syntax error.
QSqlError.TransactionError	Transaction failed error.
QSqlError.UnknownError	Unknown error.

PySide6.QtSql.QSqlError.databaseText()#

Return type:: str

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

See also

driverText() text()

PySide6.QtSql.QSqlError.driverText()#

Return type:: str

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

See also

databaseText() text()

PySide6.QtSql.QSqlError.isValid()#

Return type:: bool

Warning

This section contains snippets that were automatically translated from C++ to Python and may contain errors.

Returns true if an error is set, otherwise false.

Example:

model = QSqlQueryModel()
model.setQuery("select * from myTable")
if model.lastError().isValid():
    print(model.lastError())