In my table, I have a field for Expenses. Upon insert, I want to update the other table with the total sum of all expenses per user.
I have set up a triggered action. However, I can't get it to work because I'm having this error when I use the Sum Function: An aggregate may not appear in the set list of an UPDATE statement. (error code: SQL157)
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
MyMelody
In my table, I have a field for Expenses. Upon insert, I want to update the other table with the total sum of all expenses per user.
I have set up a triggered action. However, I can't get it to work because I'm having this error when I use the Sum Function: An aggregate may not appear in the set list of an UPDATE statement. (error code: SQL157)
Can you please help?
Thanks.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.