I have a number of screens that display and allow modification of table data in MSSQL (2014).
The records represent containers in a production environment and are used to track and validate the materials being produced and added into various processes.
One of the functions on the screens is to “empty” a container.
A request was made to allow for multiple record selections in the Power Table and essentially perform a “batch empty”.
It was a simple change, but if there are a lot of records selected (1000s) then the looping script drags and affects the performance of the client.
I was hoping to find a way to pass a list of the container IDs to a stored procedure that would then “empty” the containers on the SQL Server side, freeing up resources on the limited client machine.
One possible solution I’ve found in my searching is the use of Table-Valued Parameters.
- Is there a way to use these, without having to purchase/install third party libraries, in Ignition?
- Are there other ways to pass a list to a stored procedure and have SQL do a “mass update”?