Update – Count of read-write columns does not equal count of values [closed]

by

When I execute below update statement, I get the following error message:

SQL error code = -804
Count of read-write columns does not equal count of values

What am I doing wrong?

UPDATE PAYR P SET                
      P.BTX = P.TOTAL * 0.06 WHERE P.EMPNO IN 
     (SELECT E.EMPNO FROM EMPLOYEE E WHERE E.BTX='Yes' and E.ISACTIVE ='Yes');

I’m using this update inside a stored procedure with other update statements.

  • 1

    The SQL you have posted cannot generate the error you indicate, which means that the issue is most likely in the s.proc or the other update commands.

    – 

  • Thank You so much Ken, yes you are right the problem was in the s.proc

    – 

Leave a Comment