I SELECT B,D column,
`set global varable for each B and D
like for B`
and for D
I would like when I type COLA 1L (textbox item) the price770 for COLA1L must be in the (TExtbox Price)
but when I tried it's giveing wrong value on (textbox price).
You should know how to do this by now....
If your text is
"48301329 | COLA 0.5L | 988 | 650"
You can use the split at block, splitting at | to return the four values to a list
Then you can select by index
If you are selecting columns B and D, and if you are not restricting your query to only one row, you will get all the rows.
If you loop through the rows that arrived and you don't test for which row you want, you will do all the rows, so the result you get will be from the last row.
Guess what number is in the last row?
I know that one! 
Did you my last reply for your previous post? if so, you might have realised what would the mistake in the above blocks
