Select Where evaluation using a variable

buchea

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==<STRONG><FONT color="#800000">"xxxx"</FONT></STRONG>) );
Show(nrows(dt << get selected rows));

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

 

But the following code fails completely:

<STRONG><FONT color="#800000">sb="xxxx"</FONT></STRONG>;
dt << Row Selection( Select Where( df:TestName != "pb" & df:BoType==<STRONG><FONT color="#800000">sb</FONT></STRONG>) );
Show(nrows(dt << get selected rows));

Prints in Log: 0

 

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

 

Mark_Bailey

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));