Write to SQL table from within BPM/Directive

[josecgomez]

@JimF

I was hoping that someone who has done something similar could relay what they did (@josecgomez ?) and not feel like they were condoning writing directly to SQL without a specific reason (like this one ).

All right here’s a way to do that same thing without breaking any rules in your BPM replace that INSERT Statement with something like this (not suggesting you should do that you’ve made your position clear, just adding this as a reference for the next guy to do it “RIGHT” ← notice the quotes not ragging on ya

using(var ud01svc = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UD01SvcContract>(Db))
                    {
                         var ud01NewDS = new UD01Tableset();
                         ud01svc.GetaNewUD01(ref ud01NewDS);
                         var newUD01Row = ud01NewDS.UD01.Where(r=>r.Added()).FirstOrDefault();
                         newUD01Row .Key1= "NextIndex";
                         newUD01Row .Shortchar01 = msg;
                         ud01svc.Update(ref ud01NewDS);
                          
                    }

Same exact outcome, but coloring within the lines