Jiwa

What determines what parameters are passed into a custom form tabs stored procedure and is there a way to override it so say for example hand in extra parameters?

SBarnes wrote:What determines what parameters are passed into a custom form tabs stored procedure and is there a way to override it so say for example hand in extra parameters?

Those parameters are always the ID of the record (eg: InventoryID when looking at inventory maintenance form) (parameter RecID), the current logical warehouse (parameter IN_LogicalID) and the current staff member (parameter StaffIDSQLParam).

If you need more / different parameters then you'll need to add a tab the long way using a bit of code in a plugin, and handle the read, createend and copy events to display the contents.

Given I haven't looked at the code as to what handles it which I would assume is in the form stuff somewhere would it be possible for it to have an event added to it to hand out the SQL command like on the stocktake does so you could get at it that way, I'll log the request if it can be done but I just want to know if I am on the right track to what might be possible rather than waste time if it can't be done.