Hello,
Need your help please. I have data table that I whish to filter by using "select where case.
The filtering is by 2 parameters, one is numeric and the other is character.
I don't understand why it's not working when I'm adding the character filter as well.
Your help will be much appreciated.
Another small thing, in this function, to what do I need to change the combo box to get text box with ability to free text instead of choice list?
dt = Open( "\\Vmspfsfslc01\f28_pli\SQL\FE SQL\Data\M0R_tracer.csv" );
Summarize( a = By( :lot ) );
Insert Into( a, "<Select Traced lot>", 1 );
New Window( "Traced Lot",
<<Modal,
H List Box(
cb1 = Combo Box(
a,
<<SetFunction(
Function( {this},
selection = this << Get Selected();
r = dt << Get Rows Where( :lot == selection );
)
)
)
)
);
x = runkey[r];
y = entity[r];
dt << Select Where( :runkey > x & :entity == y );
dt << Delete rows;
