Update Syntax error

Results 1 to 2 of 2

Thread: Update Syntax error

  1. #1
    Join Date
    Dec 1969

    Default Update Syntax error

    Keep getting the following error - Syntax error in UPDATE statement.<BR><BR>Can someone please highlight my mistake.<BR>Eoin<BR>****************************** *******************<BR><BR>SQL = "update Students set Name = &#039;" & SFirstName & "&#039;,"<BR>SQl = SQL & "where Studid = &#039;" & Studid & "&#039;"

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, Errors

    There is a link to the ASPFAQs at the top right corner of this very page.<BR><BR>Look in the category noted in the subject line of this message for your question.<BR><BR>The ASPFAQs are your friends. Learn to like your friends.<BR><BR>

Posting Permissions

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