SQL statement on an InMemory Table

Is it possible to execute a SQL statement on an InMemory Table inside a .NET Heater?
I don’t need to pass any parameters and I know I can get the results I’m looking for with a few IF heaters.  Looking for a cleaner option.

JD

Hi JD,

Yes, but only simple SQL selects allowed. For example, the below listed SQLs would be possible

  object o = AdapterWrite.Execute("select [FieldName] from [TableName] where [id] = " + id.ToString(), true);
  object o = AdapterWrite.Execute("select count(*) from [TableName] where [id] = " + id.ToString(), true);

Please find attached a simple example.

 

 

The InMemory table I need the value from is not on the Read or Write side.
This is what I'm trying to do, I'm getting an error on lines 11 and 16.
Please note that C# is not my thing.

public object DoWork()
{
    if (InValues.Length == 0)
    throw new ArgumentException("min. 1 input parameters expected!");
    int i = (int)InValues[0].GetInt();

    switch (i)
    {
    //Pallet In
        case 1:
        return InMemoryAdapter.Execute("select PVAL from PRICING where PTYPE = 20", true);
        break;

    //Carton In
        case 2:
        return InMemoryAdapter.Execute("select PVAL from PRICING where PTYPE = 25", true);
        break;

    default:
    {
    //Others
        return 100;
        break;
    }
    }
}

Thanks, JD
 

Hi JD,

you just have to create a InMemoryAdapter inside the script, see below.



It would also be posible to lookup the data via the String Replace Heater like this.

 
 

Perfect
Thanks Robert

As far as the Replace Heater thanks for the tip. 
But, this is just the first step in the .NET Heater.

JD

Thanks again Robert

Works great.  Sharing this if it helps anyone else.  
Here’s what I did to work out the math.

public object DoWork(){
      if (InValues.Length == 0)
      throw new ArgumentException("min. 1 input parameters expected!");     
     
      // Create a InMemoryAdapter instance     
      InMemoryAdapter adapter1 = new InMemoryAdapter();
      InMemoryAdapter adapter2 = new InMemoryAdapter();     
      int i = (int)InValues[0].GetInt();                  //pallet = 1 carton = 2
      int iremaining = 30-DateTime.Now.Day;     //days remaining in month for initial pallet charge
      decimal ival = 0;

      switch (i)
      {      //Pallet In           
            case 1:

            //initial pallet month
            object oipallet = adapter1.Execute("select PVAL from PRICING where PTYPE = 40", true);            
            //pallet in charge
            object opalletin = adapter2.Execute("select PVAL from PRICING where PTYPE = 20", true);           
            return ival = ((Convert.ToDecimal(oipallet)*iremaining)/30)+Convert.ToDecimal(opalletin);
            break;

      //Carton In           
           case 2:

            //carton in  charge
            return adapter2.Execute("select PVAL from PRICING where PTYPE = 25", true);
            break;
      default:
      {      //Others           
            return 1000;
            break;      }
      }
}

Image shows the difference it made.

JD

 

Hi JD,

Thanks for the information. This be helpful for some others, great.

There was an error after migration the Forum software. Now it would be possible to add images. May I ask you to add your mentioned image, Thanks.
 

 You got it, thanks again.