Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. CDatabase

CDatabase

Scheduled Pinned Locked Moved C / C++ / MFC
databasemysqlsysadminhelpquestion
3 Posts 3 Posters 0 Views 1 Watching
  • 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.
  • J Offline
    J Offline
    JKallen
    wrote on last edited by
    #1

    How do I use CDatabase and CRecordset to return a list of tables in a given database. I am connecting sucessfully to a MySQL server on a unix machine. I know this because I can pass a SELECT * FROM query and get a populated recordset in return.....however when I try "SHOW TABLES FROM db_name" I get an assertion error. Thanks.

    H D 2 Replies Last reply
    0
    • J JKallen

      How do I use CDatabase and CRecordset to return a list of tables in a given database. I am connecting sucessfully to a MySQL server on a unix machine. I know this because I can pass a SELECT * FROM query and get a populated recordset in return.....however when I try "SHOW TABLES FROM db_name" I get an assertion error. Thanks.

      H Offline
      H Offline
      Hamid Taebi
      wrote on last edited by
      #2

      See MFC and MySQL[^] is helpfuls?

      1 Reply Last reply
      0
      • J JKallen

        How do I use CDatabase and CRecordset to return a list of tables in a given database. I am connecting sucessfully to a MySQL server on a unix machine. I know this because I can pass a SELECT * FROM query and get a populated recordset in return.....however when I try "SHOW TABLES FROM db_name" I get an assertion error. Thanks.

        D Offline
        D Offline
        David Crow
        wrote on last edited by
        #3

        JKallen wrote:

        ...when I try "SHOW TABLES FROM db_name" I get an assertion error.

        What line of what file is asserting?


        "Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman

        "To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups