Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. Qt Creator and other tools
  4. Qtime return time in sqlite
Qt 6.11 is out! See what's new in the release blog

Qtime return time in sqlite

Scheduled Pinned Locked Moved Solved Qt Creator and other tools
2 Posts 2 Posters 874 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    MrLibya
    wrote on last edited by
    #1

    Hello all
    I'm using sqlite in my table i add a field for time , and give it intger type

        QDateTime now = QDateTime::currentDateTime();
        QSqlQuery query("SELECT * FROM [main].[items]");
        qDebug() << query.value(3).toInt();
        qDebug() << query.lastError();
        qDebug() << now.date();
    
    

    the ouput of value3 is

    QSqlQuery::value: not positioned on a valid record
    0
    QSqlError("", "", "")
    QDate("2016-10-14")
    

    0

    1 Reply Last reply
    0
    • SGaistS Offline
      SGaistS Offline
      SGaist
      Lifetime Qt Champion
      wrote on last edited by
      #2

      Hi,

      Because you haven't called next after your query ran. See the examples in QSqlQuery documentation details.

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      1

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved