Function and UD tablesets - trouble updating

Kinetic ERP
1

Any idea why this works:

// update/validate test results

var context = (Erp.ErpContext)Ice.Services.ContextFactory.CreateContext();
var erpContext = new Erp.Internal.Lib.CCredChk(context); // used this library/assembly only for erpContext

Ice.Contracts.UD03SvcContract ud03Entry = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UD03SvcContract>(erpContext.Db, true);

using(var txscope = IceDataContext.CreateDefaultTransactionScope())        //Start Transaction
{
  foreach(var ud03_xRow in (from row in **erpContext.Db.UD03**
  where row.Company == Session.CompanyID &&
  row.Status_c == String.Empty
  select row))
  {

But this generates an error on syntax check?:

// update/validate test results

var context = (Erp.ErpContext)Ice.Services.ContextFactory.CreateContext();
var erpContext = new Erp.Internal.Lib.CCredChk(context); // used this library/assembly only for erpContext

Ice.Contracts.UD03SvcContract ud03Entry = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UD03SvcContract>(erpContext.Db, true);

**var dsUD03 = new Ice.Tablesets.UD03Tableset();**

using(var txscope = IceDataContext.CreateDefaultTransactionScope())        //Start Transaction
{
  foreach(var ud03_xRow in (from row in **dsUD03**
  where row.Company == Session.CompanyID &&
  row.Status_c == String.Empty
  select row))
  {

CS1936 Could not find an implementation of the query pattern for source type ‘UD03Tableset’. ‘Where’ not found.

On possibly a related note, this code returns a “sorry something went wrong” message unless I comment out the assignment statment - ud03_xRow.Status_c = “Validated”; - or comment out the validate.

// update/validate test results

var context = (Erp.ErpContext)Ice.Services.ContextFactory.CreateContext();
var erpContext = new Erp.Internal.Lib.CCredChk(context); // used this library/assembly only for erpContext

Ice.Contracts.UD03SvcContract ud03Entry = Ice.Assemblies.ServiceRenderer.GetService<Ice.Contracts.UD03SvcContract>(erpContext.Db, true);

using(var txscope = IceDataContext.CreateDefaultTransactionScope())        //Start Transaction
{
  foreach(var ud03_xRow in (from row in erpContext.Db.UD03
  where row.Company == Session.CompanyID &&
  row.Status_c == String.Empty
  select row))
  {
    //ud03_xRow.Status_c = "Validated";

    erpContext.Db.Validate();
  }
  
  //erpContext.Db.Validate();
  txscope.Complete();                            //Close Transaction
}

Assemblies and services as such:

image

image

image

I’d surely appreciate some direction.

Thanks,

Joe

2

Dang. One problem solved.

“Validated” exceeded the length of my status field (6).

I’d still like to figure out the issue of not being able to read through the UD03 tableset.

Joe