Find Maximum number works in Windows-Legacy but not in Windows

Help Studio
, ,
1

Hi,

Trying to get the maximum value from an excel file (from a column), the data already read into DataTable,

obj_var = dt_logArchived.AsEnumerable().Max(Function(row) row(“LastRun”))

Able to retrive the maximum number in Windows-Legacy but encounter an error in Windows

Multiple Assign: Can not assign ‘dt_logArchived.AsEnumerable().Max(Function(row) row(“LastRun”))’ to ‘obj_Var’.

2

HI,

For now, can you try to check content of $exceptionDetails at Locals panel when exception occurs? There is detailed information for the exception.

image
image1744×677 84.6 KB

Regards,

3

Hi Yoichi,

RemoteException wrapping System.NotSupportedException: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

Above is the exception message that i received.

4

HI,
It’s double quotation matter. Can you try to re-type double quote using 0x22 character " (please copy paste this character if necessary) in the expression?

Regards,

5

Hi Yoichi,

It works. But may i know why it works in Windows-Legacy but not in Windows? I didn’t change anything just convert it to Windows in Studio.

Thank you.

6

HI,

There is difference b/w Windows and Windows-Legacy regarding handling double quote. Probably it’s caused by compiling in Windows project

Regards,

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.