Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: Type TIME in MYSQL with VB6

    i have a Table in MYSQL with a type TIME
    The data stored is bigger than 24 hours.
    I can´t read any value bigger than 24 hours in Visual Basic 6.
    How can I fix this?

    (I can´t change the TYPE to STRING)

    Is there any way of forcing Visual Basic or ODBC to read an string instead of TIME (DATE)?

  2. #2
    Join Date
    Jul 2003
    Amsterdam, Nederland

    an array

    Dim x as string

    Select time from tbl where Z= Y

    x= rs.time

    do something with x

Posting Permissions

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