Return a resultset from a Dynamic SQL

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dayzz
    New Member
    • Sep 2007
    • 2

    Return a resultset from a Dynamic SQL

    [This is a duplicate. Please reply at http://www.thescripts.com/forum/thread710917.html. Closing thread - Moderator]



    Hi Everyone

    I have a code in VB that calls a Dynamic store procedure in MySQL DB, when I execute this store directly from the SQL Manager 2007 for MySQL it works very well (display the browse window with the information), but when I called from my program to create an ADO recordset, it does not return anything, seems like the table does not contain any information.

    It's there a way to return a resultset from a Dynamic SQL made in MySQL to VB6?

    Tks in advance
Working...