Iam having some trouble with updating my table. When I open the file using start, it prompts like desired, and also indicates that the rows have been updated but nothing is updated. I hope anyone can help me..Here is the code
Code:
set verify off

accept employeeName prompt 'Enter Employee Name to Change Project:'
accept EMP_projectID prompt 'Enter Old Project ID for &employeeName:'
accept EMP_projectID prompt 'Enter New Project ID:'
accept empID prompt 'Enter the Employee ID:'


prompt
accept employeeName prompt 'Enter Employee Name to Change Project:'
accept EMP_projectID1 prompt 'Enter Old Project ID for &employeeName:'
accept EMP_projectID1 prompt 'Enter New Project ID:'

UPDATE  employee
set EMP_projectID=replace(EMP_projectID,'&EMP_projectID','&EMP_projectID')
where employeeName='&employeeName';

UPDATE  employee
set EMP_projectID=replace(EMP_projectID,'&EMP_projectID','&EMP_projectID')
where employeeName='&employeeName'
and employeeID='&empID';