[Qt-interest] Incomprehensible SQL errors

[Jason H]

I can't saw for sure, but it seems from my own experience to be the parsing error catch-all.


________________________________
From: Ruth Morrison <dragonflykes at gmail.com>
To: Qt-Interest <qt-interest at trolltech.com>
Sent: Tuesday, November 15, 2011 1:12 AM
Subject: [Qt-interest] Incomprehensible SQL errors


I had a QSqlQuery that was malformed - it had a stray closing parenthesis on the end.  When it tried to execute at run-time, the call to lastError () returned "Parameter count mismatch".  This was not a QSqlQuery that had been previously used for other queries and then finish()ed.  Running the same malformed query in the SQLite 3 interpreter produces the correct error ("Error: near ")": syntax error").  Why does lastError () return "Parameter count mismatch"?   Is that just the default error for when it can't figure out what went wrong?

EK

_______________________________________________
Qt-interest mailing list
Qt-interest at qt.nokia.com
http://lists.qt.nokia.com/mailman/listinfo/qt-interest
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20111115/02653139/attachment.html