Page 1 of 1

Audit trail + Stored procedures

Posted: Fri Oct 11, 2013 8:37 am
by ephDev
Hi to all,
1)
I want to do an audit trail in nuBuilder.
I've a test table and I've set the triggers "after insert" and "after updated", what's the best way to get the user account?
Do I have to do an insert manually or nuBuilder has a built in functionality?

2)
I have a stored procedure that automatically insert a record and create a parent\child relations between 2 tables.
What's the best way to integrate this?

Thx in advance!
D.

Re: Audit trail + Stored procedures

Posted: Sat Oct 12, 2013 12:26 pm
by massiws
ephDev,
ephDev wrote:I've set the triggers "after insert" and "after updated", what's the best way to get the user account?
Do I have to do an insert manually or nuBuilder has a built in functionality?
sorry, but I don't understand: what you have to do?
ephDev wrote:I have a stored procedure that automatically insert a record and create a parent\child relations between 2 tables.
What's the best way to integrate this?
NuBulder can't manage Stored Procedure, but you can call them from RunActivity: have a look at this post.

Hope this helps,
Max