Results 1 to 20 of 20

Thread: QOpenOCCI Oracle SQL Plugin

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Dec 2008
    Location
    Lithuania
    Posts
    10
    Qt products
    Qt3 Qt4
    Platforms
    Unix/X11 Windows
    Thanks
    4

    Default Re: QOpenOCCI Oracle SQL Plugin

    Ye, you are right. there is function. Sorry for stupid question.

  2. #2
    Join Date
    Dec 2008
    Location
    Lithuania
    Posts
    10
    Qt products
    Qt3 Qt4
    Platforms
    Unix/X11 Windows
    Thanks
    4

    Default Re: QOpenOCCI Oracle SQL Plugin

    Hy a_white,
    One more question. Does QOpenOCCI plug'in support row count??? By QT documentation it returns with function query->size(), I get -1.

    the size is not supported on driver.
    qDB.driver()->hasFeature(QSqlDriver::QuerySize); returns 0.

    I don't want to use while(query->next()) tmp++; to get row count.
    QSQlQueryModel returns not the right count, and I don't know why (
    Qt Code:
    1. Model = new QModel(this);
    2. Model->setQuery(query);
    3. tmp = Model->rowCount();
    To copy to clipboard, switch view to plain text mode 
    )

    tmp = 255 in fact rows is 419

    Any suggestions...
    thanks.
    Last edited by foggy-mind; 12th March 2009 at 09:16.

  3. #3
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows
    Thanked 370 Times in 336 Posts

    Default Re: QOpenOCCI Oracle SQL Plugin

    btw, Qt 4.5.0 opensource already contains OCI driver.
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  4. #4
    Join Date
    Dec 2008
    Location
    Lithuania
    Posts
    10
    Qt products
    Qt3 Qt4
    Platforms
    Unix/X11 Windows
    Thanks
    4

    Default Re: QOpenOCCI Oracle SQL Plugin

    Quote Originally Posted by spirit View Post
    btw, Qt 4.5.0 opensource already contains OCI driver.
    very good news

  5. #5
    Join Date
    Dec 2008
    Location
    Lithuania
    Posts
    10
    Qt products
    Qt3 Qt4
    Platforms
    Unix/X11 Windows
    Thanks
    4

    Default Re: QOpenOCCI Oracle SQL Plugin

    I find the answer why QSqlQueryModel function count() returns not the real count of rows. The answer is there QSqlQueryModel::fetchMore()

    And QOCI plugin don't report back the size of a query too .

Similar Threads

  1. QPluginLoader not recognizing a plugin
    By KShots in forum Qt Programming
    Replies: 3
    Last Post: 29th June 2007, 15:13

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Qt is a trademark of The Qt Company.