[Qt-interest] SQL code is not being called

Sujan Dasmahapatra sujan.dasmahapatra at gmail.com
Sat Jun 25 22:11:34 CEST 2011


Dear Friends
In the following code after db.open(); my code is not being called.....I am
checking it through debugger I can see after db.open() code goes down to the
end . I want to check whether the tables can be seen or not. Please help me.
Thanks sujan
        db = QSqlDatabase::addDatabase("QMYSQL");

        db.setHostName("localhost");

        db.setDatabaseName("MyDB");

        db.setUserName("guest");

        db.setPassword("guest12");

        dbok = db.open();

        qDebug() << dbok << "\n";

        qDebug() << db.drivers();

        qDebug() << QCoreApplication::libraryPaths();

        QStringList tablelist = db.tables(QSql::Tables);

        for(int i=0; i<tablelist.count(); i++)

        qDebug() << tablelist.at(i) << " ";

        QSqlTableModel *model = new QSqlTableModel(this, db);

        model->setTable("things");

        model->select();

        QTableView *view = new QTableView;

        view->setModel(model);

        view->show();

-- 
Thanks & Regards
Sujan Dasmahapatra
B.E. (Aeronautics)
Bangalore, India
Ph:91-9900839788
mail id : sujan.dasmahapatra at gmail.com
yahoo msn : dasmahapatra.aerodynamics at yahoo.co.in
icq # 556023244
skype:sujan.dasmahapatra at skyepe.com
msn: sujan.dasmahapatra at hotmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20110625/be31c3a5/attachment.html 


More information about the Qt-interest-old mailing list