Results 1 to 13 of 13

Thread: Help with insert query using VB6

Hybrid View

  1. Jan 26th, 2009, 12:43 PM #1
    GaryMazzone
    GaryMazzone is offline
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: Help with insert query using VB6

    When inserting strings (text) into a database they need to be enclosed by single qoutes

    Code:
    sqlstrInsert = "INSERT INTO " & "Date_Cert_Results (Type_of_Data, Check_Area, Product_Code) values ('" & td & "','" & ca + "','" & pc & "')"
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1
    Reply With Quote Reply With Quote
  2. Jan 26th, 2009, 12:50 PM #2
    qman
    qman is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 2008
    Posts
    23

    Re: Help with insert query using VB6

    Great, thanks for the info....!
    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