I'm coding in a remoting mode. Here is my code

----Client Side

   BussInlistEntity inlist=new BussInlistEntity();
   inlist.BussinessCode="ABC";
   inlist.Fields[(int)BussInlistFieldIndex.ProductId].ExpressionToApply=new ScalarQueryExpression(BaseBinFields.ProductId,BaseBinFields.BinCode=='123456');

   ServerManager.SaveEntity(inlist);

---Server Side

   public void SaveEntity(CommonEntityBase entity)
   {
         using(DataAccessAdapter adapter=new DataAccessAdapter())
         {
                adapter.SaveEntity(entity);
         }
   }

when i monitor in server side,I found the filed "ProductId"'s CurrentValue is "null",and I set the filed "ProductId" is not null in db. So if I continue the code,an exception "null value is not allowed" throwed.

But when I use these code in "Local" mode,It will successfuly insert a new record to DB.

How can I use ExpressionToApply in a remoting mode? Especially when I want to set/update a DateTime field to "sysdate" because the timezone of Client Side and Server Side are different.

Which LLBLGen Pro runtime library version are you using?

What would happen if you use the folloiwng code at client side?

BussInlistEntity inlist=new BussInlistEntity();
inlist.BussinessCode="ABC";
inlist.ProductId = xyz;
inlist.Fields[(int)BussInlistFieldIndex.ProductId].ExpressionToApply=new ScalarQueryExpression(BaseBinFields.ProductId,BaseBinFields.BinCode=='123456');

ServerManager.SaveEntity(inlist);

Walaa wrote:

Which LLBLGen Pro runtime library version are you using?

What would happen if you use the folloiwng code at client side?

BussInlistEntity inlist=new BussInlistEntity();
inlist.BussinessCode="ABC";
inlist.ProductId = xyz;
inlist.Fields[(int)BussInlistFieldIndex.ProductId].ExpressionToApply=new ScalarQueryExpression(BaseBinFields.ProductId,BaseBinFields.BinCode=='123456');

ServerManager.SaveEntity(inlist);

I'm using V2.5

I haven't try this. why set exactly value to the field 'ProductId',and then set its ExpressionToApply?The ScalarQueryExpression's return value will not be 'xyz' and I don't know what it will be unless execute the ScalarQueryExpression.

I think this thread is related to http://llblgen.com/TinyForum/Messages.aspx?ThreadID=14726

You are using ExpressionToApply for inserts. That isn't supported (http://llblgen.com/TinyForum/Messages.aspx?ThreadID=12892)