[Qt-interest] Why the sql sentence can't be exec in QSqlQuery?

Kermit Mei kermit.mei at gmail.com
Sun Jun 14 17:51:49 CEST 2009


Hello community!

In Linux sqlite3, I can run this command and get the correct result:


sqlite> SELECT text,pos_x,pos_y,size_x,size_y FROM WidgetItem
   ...> INNER JOIN CWPage ON WidgetItem.CWPageId=CWPage.id;
btn1|0|0|32|32
btn2|0|32|32|32
btn3|0|64|32|32
btn4|32|32|32|32
btn5|32|64|32|32

But in my Qt4 code: 

query.exec("SELECT text,pos_x,pos_y,size_x,size_y"
                        "FROM WidgetItem"
                        "INNER JOIN CWPage"
                        "ON WidgetItem.CWPageId=CWPage.id;")

This is always return false.

Would you like to tell me, Why?

Thanks.

Kermit




More information about the Qt-interest-old mailing list