I’m really struggling to understand how to define a trigger so am hoping someone can help out.
The situation is as follows - I have an external SQL database already linked via the database connections and everything’s green - the DB is called "xx9000" with a table called "extract", inside that table are the following columns:
PNR|Type|Valid_until|Valid_from|Cost|CurrencyThe process itself has the following variables defined:
Part_Number|Part_Cost|Part_ExistsI than have a process which is requesting a user to enter a part number and storing it in the process variable called "Part_Number"
I want a trigger to occur after this process step where it queries the SQL database for this "Part_Number" against "PNR" - if it exists than it takes the "Cost" and adds it to the process variable "Part_Cost" and sets a process boolean (Part_Exists) to 1. If the part number doesn’t exist then it set the boolean to 0.
This is one of a few different kinds of queries I have to do, but I think once I understand this logic than the rest will be clear.
Hopefully someone can help me - thanks very much in advanced.