Skip to Content
0
May 24, 2008 at 12:34 PM

How to trigger a Stored Procedure

43 Views

I have wriiten a Stored Procedure for Delivery Document which will update the SerialNumber defined as UDF in Item Row.

But the problem is that the user has to exec the stored Procedure and have to give 2 parameters ie DocEntryNo, ItemCode.

My requirement is that at the time of Saving the Delivery Document, the Stored Procedure should be triggered and it should automatically pick the DocEntryNo and ItemCode dynamically.

At present the user has to run this Stored Procedure from Query Wizard after saving Delivery Document.

exec setSerialNumber(1234,'ItemCode')

The purpose is to display Serial Number after the ItemCode.