Is _pk_Reagent a number field or type text?
I'm just speculating as to whether the field might have an unusual character in there along with the visible number...
1 of 1 people found this helpful
BTW, a more elegant way to build a list in a loop is to do it this way:
Set Variable [$RealID ; value: List ( $RealID ; REA Reagent::_pk_Reagent ) ]
This avoids getting a leading return when the variable is empty yet does not need the IsEmpty test to do so.
The __pk_reagent is a number field for the table id. Thanks.
Sorry to rush for help. I found there is a typo on my script. The second variable is reaLD instead of reaID. Thank you very much for help.