I’m doing a BPM on HDCase.Update / In-Transaction.
I have a UD Table (UD09) that I need to join on (dbo.SerialNo)SerialNumber = (UD09)UnitSerialNumber. That will let me get the start date of that serial number from the UD09 table.
Then I can insert that value into the UD field (StartUpDate_c) in dbo.HDCase_UD. But I’m getting an error
bpm code
var query = from b in Db.SerialNo
join c in Db.UD09 on b.SerialNumber equals c.UnitSerialNumber_c
where b.Company == ttHDCase.FirstOrDefault().Company
select new
{
c.StartUpDate_c,
b.SerialNumber,
c.UnitSerialNumber_c
};
var result = query.FirstOrDefault();
if (result != null)
{
var ttHDCaseRow = ttHDCase.FirstOrDefault();
if (ttHDCaseRow != null)
{
ttHDCaseRow["StartUpDate_c"] = result.StartUpDate_c;
}
}
Unless you work with support, I think all the UD tables have generic field names, the _c notation is for custom fields added to existing tables. Did you ask support to add field to UD09?
Thanks!
