Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. International
  3. Portuguese
  4. [RESOLVIDO] Erro em query multi "insert or replace" com sqlite e Qt 4.8
QtWS25 Last Chance

[RESOLVIDO] Erro em query multi "insert or replace" com sqlite e Qt 4.8

Scheduled Pinned Locked Moved Portuguese
3 Posts 2 Posters 1.6k Views
  • 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.
  • D Offline
    D Offline
    diego
    wrote on last edited by
    #1

    Ola, no sqlitestudio 2.1.4 a query funciona mas na aplicação não.

    saida do lastQuery
    @"INSERT OR REPLACE INTO settings (field, value) VALUES ('modo','0'), ('server_ip_address','192.168.0.3'), ('server_login','teste'), ('server_passwd','123456'), ('server_folder','pessoal')"@

    saida do lastError
    @QSqlError(-1, "Unable to fetch row", "No query")@

    1 Reply Last reply
    0
    • T Offline
      T Offline
      TioRoy
      wrote on last edited by
      #2

      Várias linhas em um insert só é suportado a partir da versão 3.7.11 do sqlite (http://www.sqlite.org/releaselog/3_7_11.html)

      Eu não sei qual a versão do SQLite que vem com o Qt. Mas você consegue saber executando "SELECT sqlite_version();"

      1 Reply Last reply
      0
      • D Offline
        D Offline
        diego
        wrote on last edited by
        #3

        a versão é 3.7.7

        mudei pra varios inserts pra este caso.

        obrigado.

        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