How to get sqlite error message RAISE by trigger

[janus]

Hi,

what about

QString QSqlError::driverText () const

QString QSqlError::driverText () const

To copy to clipboard, switch view to plain text mode 

or maybe you can use

int QSqlError::number () const

int QSqlError::number () const

To copy to clipboard, switch view to plain text mode 

and get the sqlite error description from http://www.sqlite.org/c3ref/errcode.html

[miraks]

Hi Janus,

In fact, I am using QString QSqlError::text ().

In documentation, we can read:

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

So, driverText() is not the solution.

I don't know how to get the message RAISE by the trigger.

An other idea ?

[janus]

Hi,

maybe use the sqlite API directly? e.g. const char *sqlite3_errmsg(sqlite3*);
(http://www.sqlite.org/capi3ref.html#sqlite3_errcode)

from QSqlDriver:

This example retrieves the handle for a connection to sqlite:
 
 QSqlDatabase db = ...;
 QVariant v = db.driver()->handle();
 if (v.isValid() && v.typeName() == "sqlite3*") {
     // v.data() returns a pointer to the handle
     sqlite3 *handle = *static_cast<sqlite3 **>(v.data());
     if (handle != 0) { // check that it is not NULL
         ...
     }
 }

This example retrieves the handle for a connection to sqlite:

 QSqlDatabase db = ...;
 QVariant v = db.driver()->handle();
 if (v.isValid() && v.typeName() == "sqlite3*") {
     // v.data() returns a pointer to the handle
     sqlite3 *handle = *static_cast<sqlite3 **>(v.data());
     if (handle != 0) { // check that it is not NULL
         ...
     }
 }

To copy to clipboard, switch view to plain text mode 

... i used that for enabeling extension loading, but I can't find the code right now

EDit:
sry, i gave it a try ...guess my C/C++ knowledge is by far not good enought to use something like this. But using the handle to call a c sqlite function did work afair

[miraks]

Thank you for the solution !