Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unhappy Unanswered: whats wrong with this update statement

    can some one help me whats wrong with this statement. i have tried everything and can't get it to work.

    mycomm.CommandText = "Update quotes Set ID='" & Replace(TextBox3.Text, "'", "''") & "',CustomerName='" & Replace(TextBox1.Text, "'", "''") & "',DateReceived='#" & Replace(TextBox4.Text, "'", "''") & "#',DateRoutingComplete='#" & Replace(TextBox5.Text, "'", "''") & "#',DateMaterialComplete='#" & Replace(TextBox6.Text, "'", "''") & "#',DateQuoted='#" & Replace(TextBox7.Text, "'", "''") & "#',DateClosed='#" & Replace(TextBox8.Text, "'", "''") & "#' Where Id = " & QuoteIDhold & ";"

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: whats wrong with this update statement

    What does it look like if you print the value of mycomm.CommandText?

Posting Permissions

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