An expression tree may not contain a call or invocation that uses optional arguments?

Kinetic ERP
8

Try setting a variable with your OrderHed UD data and then using it in the query, like this.
You can use normal widgits, you just have to use a set variable one to set your char7 field and then the other field setter with your query.

string char07 = dsOrderHedRow.UDField<System.String>(“Character07”);
Db.UserFile.Where( r =>r.DcdUserID == char07 ).Select( r =>r.EMailAddress ).FirstOrDefault()
1 Like