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 to append a record in Microsoft Access file (.mdb)

How to append a record in Microsoft Access file (.mdb)

Scheduled Pinned Locked Moved Solved General and Desktop
3 Posts 2 Posters 487 Views 2 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
    Magdy
    wrote on last edited by
    #1

    hello guys how can i add a record to my access file.
    I succeeded to connect to my file but add the data in it is the problem with me. thanks in advanced guys.

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

      Hi and welcome to the forums.

      Cant you just use
      https://doc.qt.io/qt-5/sql-sqlstatements.html

       QSqlQuery query;
          query.exec("INSERT INTO employee (id, name, salary) "
                     "VALUES (1001, 'Thad Beaumont', 65000)");
      

      and normal SQL ?

      M 1 Reply Last reply
      4
      • mrjjM mrjj

        Hi and welcome to the forums.

        Cant you just use
        https://doc.qt.io/qt-5/sql-sqlstatements.html

         QSqlQuery query;
            query.exec("INSERT INTO employee (id, name, salary) "
                       "VALUES (1001, 'Thad Beaumont', 65000)");
        

        and normal SQL ?

        M Offline
        M Offline
        Magdy
        wrote on last edited by Magdy
        #3

        @mrjj thanks for your help it solved the problem

        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