Results 1 to 2 of 2

Thread: database question

  1. #1
    Join Date
    Mar 2009
    Location
    Nashville Tn.
    Posts
    53
    Thanks
    14
    Thanked 1 Time in 1 Post
    Qt products
    Qt4
    Platforms
    MacOS X Unix/X11 Windows

    Default database question

    is there a limit on Qt's mysql driver as to how many columns it will work with or is there ANY limit on the mysql driver ?

    this syntax returns -1
    QSqlQuery query("SELECT * FROM artistdates" );


    this syntax returns correct
    QSqlQuery query("SELECT * FROM users" );

    these tables are in the SAME database.

    i copy the select statements to mysql browser and both work as expected. the only thing i can think of is column count (artistdates has 92 cols, 8500 records) .

    this syntax returns correctly !!!
    QSqlQuery query("SELECT startdate, code, city FROM artistdates" );





    Last edited by rogerholmes; 7th May 2009 at 00:30.

  2. #2
    Join Date
    Mar 2009
    Location
    Nashville Tn.
    Posts
    53
    Thanks
    14
    Thanked 1 Time in 1 Post
    Qt products
    Qt4
    Platforms
    MacOS X Unix/X11 Windows

    Angry Re: database question

    I found it ....

    IT is Decimal fields. !!! apparently the driver cant work with them is this possible??
    Last edited by rogerholmes; 7th May 2009 at 04:23.

Similar Threads

  1. Threads and database connection
    By probine in forum Qt Programming
    Replies: 9
    Last Post: 7th August 2013, 08:30
  2. A database question
    By Morea in forum Qt Programming
    Replies: 1
    Last Post: 29th January 2009, 23:04
  3. Multiple database connections
    By cyberboy in forum Qt Programming
    Replies: 3
    Last Post: 30th March 2008, 16:56
  4. Database Master-Detail Entry Form
    By Phan Sin Tian in forum Newbie
    Replies: 4
    Last Post: 3rd February 2008, 14:31
  5. Filling combobox from database
    By Philip_Anselmo in forum Qt Programming
    Replies: 3
    Last Post: 11th May 2006, 17:53

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
  •  
Qt is a trademark of The Qt Company.