Results 1 to 3 of 3

Thread: Update Help

  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Unanswered: Update Help

    UPDATE EMPLOYEE
    SET Emp_Name ='William Brown'
    WHERE Emp_Name ='Randy Brown'

    Whats wrong with the above update code? i keep getting sqlstate=42601 whenever i run it. Can someone show me how to do an update statement? Thanks.

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Update Help

    can you post the sql message or the full error message if possible?

    dollar

    Originally posted by Shinto
    UPDATE EMPLOYEE
    SET Emp_Name ='William Brown'
    WHERE Emp_Name ='Randy Brown'

    Whats wrong with the above update code? i keep getting sqlstate=42601 whenever i run it. Can someone show me how to do an update statement? Thanks.

  3. #3
    Join Date
    Jan 2004
    Posts
    25

    Re: Update Help

    Originally posted by dollar489
    can you post the sql message or the full error message if possible?

    dollar
    NVM, i managed to solve the problem. Thanks anyway.

Posting Permissions

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