Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. How can I open an existing Sqlite database?

How can I open an existing Sqlite database?

Scheduled Pinned Locked Moved General and Desktop
3 Posts 3 Posters 10.7k 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.
  • F Offline
    F Offline
    freecamellia
    wrote on last edited by
    #1

    Hi,

    If my database data.sqlite is located in my project folder, how can I call it and read/right from it. I want the database be a part of my project, not just an external file.

    1 Reply Last reply
    0
    • V Offline
      V Offline
      veeeee_d
      wrote on last edited by
      #2

      @QSqlDatabase db = QSqlDatabase:addDatabase("QSQLITE");
      db.setDatabaseName("data.sqlite");
      bool opened = db.open();@

      Also, add sql to your project's .pro, for example:

      @QT += core sql
      QT -= gui@

      1 Reply Last reply
      0
      • G Offline
        G Offline
        goetz
        wrote on last edited by
        #3

        @
        db.setDatabaseName("data.sqlite");
        @

        searches in the current working directory, if that's wrong, give an absolute path as the argument.

        http://www.catb.org/~esr/faqs/smart-questions.html

        1 Reply Last reply
        0

        • Login

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