Bind dataset col value to LED

Archived Topics
1

Hi,

I have a SQL tag, whose value is a dataset. It only has one row. I am trying to bind one of the columns values to a LED display.

I’m very new to FactoryPMI - please help.

Thanks,
Johan

2

Hi,

To bind into a dataset you have to use an expression. Open the binding window, select “expression”, and then link to your tag using the button to the right. You can index into the dataset by adding “[row,col]” after the reference. The only trick here is that you’ll have to cast the result, by wrapping it in one of the “toType” functions.

So, ultimately you’ll end up with something like:

toDouble({[Client]Tag}[0,0])

Regards,

1 Like