Qt Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Unsolved

    Solved QSqlQuery for ms access database

    General and Desktop
    4
    24
    1465
    Loading More Posts
    • 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.
    • behruz montazeri
      behruz montazeri @SGaist last edited by

      @sgaist
      As i mentioned this one :

          QSqlQuery  query ;
          query.prepare("SELECT * FROM names where name like ? ");
          query.addBindValue(st);
      

      It works but i should write entire word i want to write a part of record in my case name record and it update QTableView

      1 Reply Last reply Reply Quote 0
      • SGaist
        SGaist Lifetime Qt Champion last edited by

        What I am asking for is an example without binding that is working. Once we have that it should be easier to come with a solution.

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

        behruz montazeri 1 Reply Last reply Reply Quote 2
        • behruz montazeri
          behruz montazeri @SGaist last edited by

          @sgaist
          I have no idea.

          SGaist 1 Reply Last reply Reply Quote 0
          • RonaldViscarraL
            RonaldViscarraL last edited by

            Hi, the use of % instead of * is the right way. The * is only for using it directly on ms access query.

            WHat version of ms access are you using? could you post a screenshot of your database/table?

            behruz montazeri 2 Replies Last reply Reply Quote 0
            • behruz montazeri
              behruz montazeri @RonaldViscarraL last edited by behruz montazeri

              @ronaldviscarral
              Thanks for your response here is my screenshot :
              image Info
              link imaget

              1 Reply Last reply Reply Quote 0
              • behruz montazeri
                behruz montazeri @RonaldViscarraL last edited by behruz montazeri

                This post is deleted!
                1 Reply Last reply Reply Quote 0
                • SGaist
                  SGaist Lifetime Qt Champion @behruz montazeri last edited by

                  @behruz-montazeri said in QSqlQuery for ms access database:

                  @sgaist
                  I have no idea.

                  Something like "SELECT * FROM names where name like '%foo%'" to confirm that one is working properly.

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

                  behruz montazeri 1 Reply Last reply Reply Quote 0
                  • behruz montazeri
                    behruz montazeri @SGaist last edited by behruz montazeri

                    @sgaist
                    Yes that works.Then what should be inside the % % instead of foo for binding ???
                    what about binding ??

                    1 Reply Last reply Reply Quote 0
                    • RonaldViscarraL
                      RonaldViscarraL last edited by

                      try this:

                      QSqlQuery  query ;
                      query.prepare("SELECT * FROM names where name like '%?%'" );
                      query.addBindValue("a");
                      
                      1 Reply Last reply Reply Quote 0
                      • RonaldViscarraL
                        RonaldViscarraL last edited by

                        I tested in Qt using access both 32 bits, this code works for me:

                        QString st = "a";
                        query->prepare("SELECT * FROM names WHERE name LIKE ?;");
                        
                        QString criteria("%" + st + "%");
                        query->addBindValue(criteria);
                        
                        behruz montazeri 1 Reply Last reply Reply Quote 1
                        • behruz montazeri
                          behruz montazeri @RonaldViscarraL last edited by

                          @ronaldviscarral
                          Thank you very much it works now.

                          1 Reply Last reply Reply Quote 0
                          • First post
                            Last post