If I could see the SQL I could probably figure this out, but... This is my first Trigger. Not a good start.
The Situation:
I have a Log table (WeightLog). When an entry is either Added, Updated, or Deleted, I need to update MyProfile table with two fields (Weight and LastWeightUpdate)
Because I don't know where the user added, updated or deleted the record, I need to sort the records and take the top 1 record and assume that is the most current record.
What I got Validated (It doesn't mean they work, it just means they validated):
The SET and the LEFT join
The error I am getting is "2098: Only one value is expected." Which is kinda what I want. Only 1 record returned in order to update.
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
Lynda
If I could see the SQL I could probably figure this out, but... This is my first Trigger. Not a good start.
The Situation:
What I got Validated (It doesn't mean they work, it just means they validated):
The error I am getting is "2098: Only one value is expected." Which is kinda what I want. Only 1 record returned in order to update.
Any ideas on what is wrong with this?
Lynda
Link to comment
Share on other sites
1 answer 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.