Run Event for Stored Procedure when record selection changes

I have a stored procedure that updates a user defined field on the Items form. I want this procedure to run every time the item record changes to another record. What is the best way to do this?

Find more posts tagged with

UI Design

Accepted answers

Legacy Contributor

Setup an event handler. Usually i think there is already one called itemchanged() in the items form. Add this stored procedure as a method call in the last sequence of that event(in this case the event would be itemchanged()). It would execute the procedure everytime the item is loaded into the form. You would have to define the input and output parameters on the method call as it is in the stored procedure.

Hope that helps

All comments

Legacy Contributor

You can call stored procedures via form script by doing something like the following:

Dim nRetVal As InvokeResponseData

Dim nRequest As New InvokeRequestData()

nRequest.IDOName = "SP!"

nRequest.MethodName = "_VOL_UpdateTransferPackageNum"

nRequest.Parameters.Add(ThisForm.PrimaryIDOCollection.GetCurrentObjectProperty("TrnNum").ToString())

nRequest.Parameters.Add(ocache.GetObjectProperty("TrnLine", subidx).ToString())

nRequest.Parameters.Add(ocache.GetObjectProperty("trnUf_Package_Num", subidx).ToString())

nRetVal = IDOClient.Invoke(nRequest)

This is just a piece of the code I'm using for this but you can see you put the stored procedure name into MethodName, and then add parameters in the order they are defined in SQL. You can then call the subroutine you create in the form script on any event in SyteLine. I'm not sure specifically which event would get the desired behaviour here though - maybe StdObjectSelectCurrent (not sure whether the new object or the old one will still be selected on this event). One thing to keep in mind with doing this though would be if you changed records in the Items form and then wanted to modify the original one, you would now have to refresh the collection (or at least that first record) as it would have been modified. Hope this helps.

Legacy Contributor

Thank you, this was what i was looking for. The only problem is that there is no event handler called itemchanged() for the items form, unless I am looking in the wrong place. I also looked at the Item field and tried creating my own event handler when the item gained focus, but that didn't work. I have made a button that will successfully run my stored procedure, but I need the sp to run when the record is selected.

I have also noticed now that when I run the stored procedure to update the values in my UDF fields on the User Defined Tab, the changes in value are not being recognized as a data change and therefore not making the SAVE button available. Also doesn't show the record change asterisk on the record. I have done a similar sp updating the overview field and never had this happen, have I change a setting inadvertently?

Any further help would be greatly appreciated.

Legacy Contributor

Try creating a new event handler using the StdObjectSelectCurrentCompleted event. Then add your stored procedure to this event.

M3 CloudSuites - Update.pdf

Legacy Contributor

That's the ticket David....it's the correct Event. Thanks.

Copyright © 2025 Infor. All rights reserved.