QSqlite and Regexp
-
Hello,
I have the following problem when executing the following query with QSqlQueryModel::setQuery() :
Simplified code:
@"SELECTid
FROMtable
WHERE REGEXP('1')"@When I remove the regexp function everything works just fine.
Does QT not support REGEXP function with its SQLite driver or am i missing something here?My Operating System is Win7 64bit using Qt 5.0.1
Thx in advance.
-
Hi and welcome to DevNet,
From the "Sqlite doc":http://www.sqlite.org/lang_expr.html#regexp it is said that by default there is no regexp() function implemented. You have to add you own.
Hope it helps
-
Thank you for the very fast reply.
My regexp is not that complicated so i can work around it :)