Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2004
    Location
    UK
    Posts
    15

    Unanswered: Copy MySQL variables to application variables...

    Is it possible to copy a MySQL variable to a vba application variable without the use of a recordset?

    Using a recordset:
    ...
    qdfPassThrough.ReturnsRecords = False
    qdfPassThrough.SQL = "SELECT @cnt := COUNT( * ) FROM some_table;"
    qdfPassThrough.Execute
    qdfPassThrough.ReturnsRecords = True
    qdfPassThrough.SQL = "SELECT @cnt;"
    Set rs = qdfPassThrough.OpenRecordset()
    MsgBox rs(0)


    Thanks in advance
    Ed
    Last edited by Odders; 01-19-05 at 05:03.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •