Results 1 to 3 of 3

Thread: VB Problem

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: VB Problem

    I have a VB6 application that takes data from a MySQL table and uploads it to a datagrid. I have a column in my SQL table that is of timestamp. My problem is this. When the SQL field is set to timestamp and I click to return the data to the datagrid, I get no results. When I set the SQL field to something else other than timestamp the results are returned to the datagrid. Also, when I set the field to datetime, I get nothing returned. Has someone seen this before, and if so, what can be done?
    Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    5

    Re: VB Problem

    I have seen this before where I work, though I have merely band-aided my way through it. You can either convert the date to char (best if not in need of hh:mm:ss) otherwise, I have found it best to either query on a >, < or between for the date. (note not using >= or <=, this will leave you with > or < but not provide the = information)

    Hope this helps

    Trayc

  3. #3
    Join Date
    Aug 2003
    Posts
    328

    Re: VB Problem

    I'll try that thanks.

Posting Permissions

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