topic Re: Select Where evaluation using a variable in Discussions

Select Where evaluation using a variable

buchea — Fri, 09 Jun 2023 23:30:51 GMT

I'm having a strange issue when trying to use a variable in Select Where(). The following code works fine:

dt << Row Selection( Select Where( df:TestName != "pb" & df:BoType=="xxxx") );
Show(nrows(dt << get selected rows));

Prints in Log: Number of selected rows > 0 as expected.

But the following code fails completely:

sb="xxxx";
dt << Row Selection( Select Where( df:TestName != "pb" & df:BoType==sb) );
Show(nrows(dt << get selected rows));

Prints in Log: 0

I'm completely baffled. Any help would be greatly appreciated!

Mark_Bailey — Wed, 01 Jul 2020 19:27:03 GMT

I'm pretty sure that I have done this action without trouble. Perhaps simplify the message.

sb="xxxx";
dt << Select Where( df:TestName != "pb" & df:BoType == sb);
Show(nrows(dt << get selected rows));

buchea — Wed, 01 Jul 2020 19:52:08 GMT

This fixed it! Thank you!