Results 1 to 6 of 6

Thread: SQLite plugin - Dump entire table to a label similar.

  1. #1
    Join Date
    Aug 2010
    Posts
    28
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default SQLite plugin - Dump entire table to a label similar.

    Hello,

    This is my first serious project in Qt and I am hitting a minor roadblock on two things (Though issue number two is for a separate thread!).

    Essentially, I have a form set up that it takes data from two lineEdits and puts them in an SQLite database. This works as expected though getting the information back out is a challenge.

    I am currently sending a query of "select * from table;" by the query.exec(); but I only get the first entry.

    If anyone has any pointers or relevant documentation, I would greatly appreciate it.

    Thank you

  2. #2
    Join Date
    Jan 2006
    Location
    Germany
    Posts
    4,380
    Thanks
    19
    Thanked 1,005 Times in 913 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows Symbian S60
    Wiki edits
    5

    Default Re: SQLite plugin - Dump entire table to a label similar.

    QSqlQuery::next() and in the detailed section you will find good examples. And please use the newbie section and try to lookup yourself next time.

  3. #3
    Join Date
    Aug 2010
    Posts
    28
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: SQLite plugin - Dump entire table to a label similar.

    Appreciated.

    I was using that, but incorrectly it seems!

    Thank you!

  4. #4
    Join Date
    Jun 2010
    Location
    Salatiga, Indonesia
    Posts
    160
    Thanks
    11
    Thanked 32 Times in 29 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows
    Wiki edits
    1

    Default Re: SQLite plugin - Dump entire table to a label similar.

    can you post some codes where you execute QSqlQuery::next().

  5. #5
    Join Date
    Aug 2010
    Posts
    28
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: SQLite plugin - Dump entire table to a label similar.

    Sadly not anymore... I used the link above and have it working now!

    The "Thank you" above was genuine, haha!

  6. #6
    Join Date
    Jun 2010
    Location
    Salatiga, Indonesia
    Posts
    160
    Thanks
    11
    Thanked 32 Times in 29 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows
    Wiki edits
    1

    Default Re: SQLite plugin - Dump entire table to a label similar.

    Ups. My bad.

Similar Threads

  1. Replies: 2
    Last Post: 4th August 2010, 13:06
  2. Replies: 2
    Last Post: 12th May 2010, 18:48
  3. Loading SQLite plugin. Again!
    By miwarre in forum Newbie
    Replies: 5
    Last Post: 12th November 2009, 10:23
  4. dump table and db
    By subratatamal in forum Qt Programming
    Replies: 1
    Last Post: 31st December 2008, 16:38
  5. Replies: 0
    Last Post: 4th December 2008, 05:48

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.