SQL Business rule run After New action, using new ID value.
I want to run a stored procedure after creating a new record, using that new record's new ID value.how would I go about doing that.
-
Personally, I would add a trigger (after insert) on the table in the database to get the ID of the inserted record and run the stored proc.
-
-
EMPLOYEE
1Implement a business rule with command name set to Insert in phase to After.
Command New allows setting up default values. -