Get Satisfaction uses Javascript and cookies.

You'll need to enable Javascript and cookies to participate.

Create a new topic

About this Question

SQL Business rule run After New action, using new ID value.

Edit Subject

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.

1 person has
this question +1

Answered

0

Edit

Delete

Remove

Official

Fork

Peter Young October 16, 2019 15:15

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.

Comment

good answer! good answer! (undo)
- Cancel
Edit Your Reply (some HTML allowed)
What's the status of this question?

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.

How does this make you feel? Add Image

I'm
e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited
Cancel
EMPLOYEE

1

Edit

Delete

Remove

Official

Fork

Customer Service (Company Admin) October 16, 2019 23:21

Implement a business rule with command name set to Insert in phase to After.

Command New allows setting up default values.

Comment

good answer! good answer! (undo)
- Cancel
Edit Your Reply (some HTML allowed)
What's the status of this question?

Implement a business rule with command name set to <i>Insert</i> in phase to <i>After</i>. Command <i>New</i> allows setting up default values.

How does this make you feel? Add Image

I'm
e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated
Cancel

Reply to This Topic (some HTML allowed)
What's the status of this question?

How does this make you feel? Add Image

I'm
e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned