Update Help

Shinto · #1 (**permalink**) 02-04-04, 20:29

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.

dollar489 · #2 (**permalink**) 02-04-04, 20:42

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

dollar

Quote:

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.