Results 1 to 9 of 9

Thread: SQL Statement error or Data Type error? (RESOLVED)

Threaded View

  1. Apr 25th, 2005, 12:20 AM #1
    Apek
    Apek is offline

    Thread Starter
    Hyperactive Member Apek's Avatar
    Join Date
    Aug 2002
    Location
    Kg Melayu,2 33 °N,102 10 °E
    Posts
    283

    Resolved SQL Statement error or Data Type error? (RESOLVED)

    VB Code:
    1. SELECT MC_NO, PART_CODE,MONTH " & _

    2.         "FROM MC_DATA " & _

    3.         "WHERE MC_NO = '& txtM1.Text &' AND MONTH = '" & txtMonthHide.Text & "'

    above is my sql statement...but i get an error "Data Type Mismatch in criteria expression. i think the error refers to MC_NO = '& txtM1.Text &', because there is no value when i debugged it.FYI the data type for MC_NO in MS Access database is Number..can somene correct my coding mistake??
    Thanks in advance.
    Last edited by Apek; Apr 25th, 2005 at 12:58 AM. Reason: Resolved
    "The reason you see open source there at all is because we came in and said there should be a platform that's identical with millions and millions of machines."
    Get it HERE


    Regards..
    Apek
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width