Also, if it wasn’t clear from the title, this is in an Epicor Function. Ok, let me explain first, before everyone jumps on me :slight_smile: I am working purely with a UD Table. I wanted to add a record to UD20, with a direct DB Update. Not here to discuss really whether this is good or bad. Bu…

Well, short answer you cant Longer answer you can, but its a security issue and I’m not sure you should. :neutral_face: Wait I found the right knob!! You have to hit updatable in the Table just setting the function as writable doesn’t matter [image] Then you can Db.AddObject and Db.DeleteObject…

I never tried, I assumed you could, because you could do modifications directly.

I guess, to me it was always easier to just use the BO… But you made weird rules here. I guess I’m not sure.

Lol, well that’s what I did, I used the BO. This is a logging function, I was just trying to keep the overhead down as much as possible. I’d still like to know if it’s possible. Why can I chose a record, and update it, but I can’t add a record ?

The UD Bo’s are pretty damn lightweight. I’m not sure you’re going to gain much.

[image] Banderson: I’m not sure you’re going to gain much You’re probably right. I gotta know though :rofl:

Did you set your Db Context to Read / Write?

Worked yay, and no function security violations :tada: UD20 ud20Row = new UD20() { Key1 = Guid.NewGuid().ToString() }; Db.AddObject(ud20Row); Db.SaveChanges();

Now I want a full statistical analysis of how much time you gained… [image]

[image] Banderson: Now I want a full statistical analysis of how much time you gained… I’m not gonna rewrite it. Too lazy. [Video Games GIF by South Park]

Direct DB Update, Add Row, Epicor Function - Cannot Add, am I missing something?

Kinetic ERP

klincecum (Kevin Lincecum) March 3, 2023, 10:05pm 15

If anybody is curious, I was so jealous of @hmwillett 's Log Table I started working my own.

Topic		Replies	Views
Direct DB Update, Update UD column, Epicor Function Kinetic ERP kinetic , functions	8	4677	March 6, 2023
uBAQ to UD table help Kinetic ERP kinetic , ubaq	21	1737	October 27, 2023
Function updating DB table Kinetic ERP	7	4156	April 4, 2023
BPM to record changes in UD table? Epicor ERP 10 e10 , bpm , changelog	55	11871	June 11, 2020
Insert UD Table Records from a BPM Epicor ERP 10 bpm	13	17342	October 19, 2020

Direct DB Update, Add Row, Epicor Function - Cannot Add, am I missing something?

Related topics