Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-57407

qsqltablemode::setsort(…) and setFilter("limit 5,5") error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Incomplete
    • Icon: Not Evaluated Not Evaluated
    • None
    • 5.3.2
    • SQL Support
    • None

      After use "setSort(0,Qt::AscendingOrder)", I use setFiler("limit 0,10") or setFilter("1=1 limit 0, 10") in a qsqltablemodel, the select() will return QSqlError("1", "Unable to execute statement", "near "ORDER": syntax error").

      why,please help me,thanks

        1. QtError.png
          QtError.png
          16 kB
        2. QtError2.png
          QtError2.png
          3 kB
        3. QtEV.png
          QtEV.png
          30 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            mabrand Mark Brand
            boy 宋
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes