TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Don
NA
1
966
Trigger to update field based upon what's inserted
Jun 12 2014 10:54 AM
Hi All,
Likely an easy question, but I can't find exactly what I need by searching. Running SQL2000. I have a VB program that looks at our ERP data every 30 minutes and sends out emails or updates data in order to address common things missed by our sales people, etc.
I now have a need to have one section of the program to be instantaneous so I want to make a trigger. Here's a section from the old program (it's fitlered to only those records that are missing the ProdFam field:
Do While Not rsSales.EOF
Select Case Left(rsSales.Fields("IMA_ItemID").Value, 5)
'AMAT et al
Case "1014-", "1014A", "1095-", "1995-", "2028B", "2028P", "2092-", "2096-", "3030-", "3095-", "3096-", "4028-"
rsSales.Fields("IMA_ProdFam").Value = "AMAT"
'Analog SCR
Case "1027A", "1028A", "1029A", "1029B", "1029C", "1029D", "1037A", "1039-", "1039I", "3027-", "3037-", "3337-", "3629C", "3869"
rsSales.Fields("IMA_ProdFam").Value = "Analog SCR"
(many more cases here, removed for ease of reading)
End Select
rsSales.Update
rsSales.MoveNext
Loop
Basically, it just looks at the root of the ItemID and decides what product family the Item belongs in and then sets the ProdFam field.
I have no idea how to do this in a trigger. Can someone give me a start on this or is that asking too much?
I will appreciate any help you can give me,
Don
Reply
Answers (
0
)
SQL Query problem
How to Find Only Alphanumeric values from column