Bulk update

Hi everyone,

I am looking for a way to replace an update statemnt like below with form script in Syteline. The only way i can think of is to load this collection and loop through every single record and perform an update. Please let me know if there's an easier way to accomplish this. Thank you so much for your help.

update item set stat = 'O' where stat='I'

Find more posts tagged with

Accepted answers

All comments

dean-bradko

Unless you're interacting directly with the database, I think loading a collection and iterating through it is the only way. That said, I have yet to see any of the Infor utilities do it that way - they always call an IDO method linked to an extension method or stored procedure.

dean-bradko

I'd extend the SLItems IDO and add an Extension method similar to the following:

        [IDOMethod(MethodFlags.None, "Infobar")]
        public void UpdateItemStatuses(out int numItemsUpdated,
                                       out Boolean success,
                                       out String infoBar)
        {
            numItemsUpdated = 0;
            success = true;
            infoBar = "";

            try
            {
                using (ApplicationDB appDB = IDORuntime.Context.CreateApplicationDB())
                {
                    using (IDbCommand cmd = appDB.CreateCommand(CommandType.Text, "UPDATE item SET stat = 'O' WHERE stat = 'I'"))
                    {
                        numItemsUpdated = cmd.ExecuteNonQuery();
                    }
                }
            }
            catch (Exception ex)
            {
                infoBar = ex.Message;
                success = false;
            }
        }

Copyright © 2025 Infor. All rights reserved.