Skip to content
Advertisement

Error “Column does not belong to referenced table.” in procedure with update clause

I work with IBExpert. I want to increase column STIP by IND percent in update clause in my stored procedure PR_INDEXSTIP. For example, if input parameter will be 0.25, I need to increase my field STIP by 25%. And I think that in set clause I should to write: STIP = 1.25*STIP. So, I have this code (don’t pay attention to returns clause):

I have an error in this code:

I can’t resolve this error. I tried to write many different code variations and I still have the error that column STIP is unknown.

Advertisement

Answer

I resolved this problem.

Code:

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement